USERELATIONSHIP needs selection to trigger correct calculation of measure? What am I missing?
This might be a stupid question, but I seem to have a general misunderstanding when using Measures, Filters and the DAX USERELATIONSHIP function.
I seems to work just fine for my dataset, but I always need to make a selection thus filter the data for which it then evaluates the measure using USERELATIONSHIP correctly. If I unselect everything it seems to ignore the USERELATIONSHIP calculation and gives the results without it.
I just have 2 tables with an inactive relationship:
My measure is showing distinct values as such:
distinct 2s also in 1 =
DISTINCTCOUNT('Table (2)'[number 2]) ,
'Table (2)'[number 2]
My expected outcome here would be 2, yet it shows as 3. It is counting the number 2 value '9' which is not in Table 1.
If I make a selection in the number 1 table it shows the values correctly as only '1'
How can I get the result of '2' for my measure posted above that works without a selection?
I uploaded a very simple pbix file to show what I mean.