Forum Discussion
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 editted visual interaction between tables and slicers but i need difference between them like
diffference showing between them please help me around if i can create measure for the same to get difference. Please help me with this.
Thanks in advance, hope i get positive reply soon...
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 - test2Did I answer your question? Mark my post as a solution!
Best RegardsLucien
1 Reply
- v-luwang-msft
Community Support
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 - test2Did I answer your question? Mark my post as a solution!
Best RegardsLucien