Zoe Douglas gives a visual cue that not all is well:
Have you ever put a measure on a visual with a column from a table and found it repeated the same value for every row and the total? This indicates there is no relationship for that measure and the column. And that simply may be the case, as in, there is no relationship to create. Let’s look at how we can account for that in a different way, by showing a placeholder value such as ###.
Read on to see how.