Forum Discussion

sajjadkhan's avatar
sajjadkhan
New Member
4 years ago
Solved

need to get difference between 2 tables having 2 same slicers with interaction enabled

Hi Team amitchandak sir, Ashish_Mathur sir, Hope all are doing good.   I have 2 date slicers from same column and 2 tables having same column from same table example  where i have editt...
Need Help
v-luwang-msft's avatar
v-luwang-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi sajjadkhan ,

Pls test the below measure:

differnet =
VAR test1 =
    CALCULATE (
        MAX ( Table1[value] ),
        FILTER ( ALLSELECTED ( Table1 ), Table1[Type] = MAX ( Table1[Type] ) )
    )
VAR test2 =
    CALCULATE (
        MAX ( Table2[value] ),
        FILTER ( ALLSELECTED ( Table2 ), Table2[Type] = MAX ( Table1[Type] ) )
    )
RETURN
    test1 - test2

 

 

Did I answer your question? Mark my post as a solution!


Best Regards

Lucien