Forum Discussion

systemic_till's avatar
systemic_till
Regular Visitor
6 years ago

USERELATIONSHIP needs selection to trigger correct calculation of measure? What am I missing?

Hey, 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, ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi systemic_till ,

You can add write measure to calculate table2 records with if statement to compare current row contents with tbale1 records:

Measure =
IF (
    SELECTEDVALUE ( 'Table (2)'[number 2] ) IN VALUES ( 'Table'[number 1] ),
    CALCULATE (
        COUNT ( 'Table (2)'[number 2] ),
        USERELATIONSHIP ( 'Table'[number 1], 'Table (2)'[number 2] )
    )
)

If above not help, please explain your requirement more clarify with the expected result.

Regards,

Xiaoxin Sheng