Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

USERELATIONSHIP ISSUE !!!!!

Dear All,   I have an issue with the USERELATIONSHIP dax function, I have a blank result when I use it on my measures : First of all this is my schema :     Then this is my measures : ...
Need Help
Tips and Tricks
Mariusz's avatar
Mariusz
Community Champion
6 years ago

Hi Anonymous 

 

It might be to do with the decision that the engine has to make to switch off one of the relationships with Date table, try this.

 

AmountTotal_1 =
CALCULATE (
    SUM ( Table1[amt] );
    DATESINPERIOD ( Date[Date]; MAX ( Date[Date] ); 10; YEAR );
    USERELATIONSHIP ( Table1[ID]; Table2[ID] );
    CROSSFILTER( Table1[Date]; Date[Date]; none )
    -- or CROSSFILTER( Table2[Date]; Date[Date]; none )
)

 

 
Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn