Forum Discussion
How to compare data from multiple slicers with different tables
If you want to compare lefts vs right slicers then remove all your relationships, duplicate your dimension tables and call then left and right. For example:-
Create slicers linked to the left and right tables.
Then create DAX measure to get the left and right values, for example:
Left qty = CALCULATE( SUM(Sales[Qty]), Sales[Brand] = SELECTEDVALUE('Left'[Left brand]))Right qty = CALCULATE( SUM(Sales[Qty]), Sales[Brand] = SELECTEDVALUE('Right'[Right brand]))Download this example and look at the reklationships and dax.
I am an unpaid voluntrer helper so please show your thanks by clicking thumbs up and accept solution, because the example shows a working example on how to do it. I prefer to show members how to solve problems, so they can learn how to adapt it to their problems, rather than just give them an oneoff solution.
Super UserIf you want to compare lefts vs right slicers then remove all your relationships, duplicate your dimension tables and call then left and right. For example:-
Create slicers linked to the left and right tables.
Then create DAX measure to get the left and right values, for example:
Left qty =
CALCULATE(
SUM(Sales[Qty]),
Sales[Brand] = SELECTEDVALUE('Left'[Left brand]))Right qty =
CALCULATE(
SUM(Sales[Qty]),
Sales[Brand] = SELECTEDVALUE('Right'[Right brand]))Download this example and look at the reklationships and dax.
I am an unpaid voluntrer helper so please show your thanks by clicking thumbs up and accept solution, because the example shows a working example on how to do it. I prefer to show members how to solve problems, so they can learn how to adapt it to their problems, rather than just give them an oneoff solution.
Hi, thank you for your quick response. I have found similar solution to your response, but unfortunately it's not what I wanted. I think your solution might only work if all data that I have come from one same table. Therefore, relationship is not needed. In my case, I might need to keep the relationship so that I can get the "vlookup" value from the other table. Besides, the slicers are multiple and not from the same table. Do you have any other solution?