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.
It is important you understand that slicers and relatioonships do what they say on the tin. They slice and relate !
If I have cake with clock face and you slice 1am to 5am, then you can't also slice 7pm to 11pm.
You can only do it with 2 unrelated tables if you wish to compare left with right.
The example I provide works and answers your orginal question.
It is not my fault you are now changing the question.
I am unpaid volunteer and expect kudos.
Please accept the solution and raise a new question with example data and clear description of what is you need and quote speedramps and I will try help.
Hi,
Apologize for the confusion.
My question is still the same, but now allow me to provide you with the example data. You can find the example of the pbix file and excel file here: https://drive.google.com/drive/folders/1FxCk0J08gqc20N5xAYXZtLvmeSu41MLI?usp=sharing
I have replicated what I am trying to achieve, but is there any better way to do this? I need to maintain the slicers to be dynamic based on selected values on the other slicers within the same group as well. Thank you! speedramps
No confussion here budhie
You asked the wrong question orignally. I answered it. This solution works and does exactly what you asked. You have now change the question and expcet more help but won't give Kudos back.
So please quickly click the [accept as solution] and the thumbs up button to leave kudos.
One question per ticket please. If you need to change or extend your request then please raise a new ticket.
Remember we dont work for Micrsoft, we are unpaid volunteers, and you have got free expert help which took a lot of effort,
You will get a quicker response and each volunteer solver will get the kudos they deserve. Thank you !
If you quote speedramps in your next tickets then I will then receive an automatic notification, and will be delighted to help you again.
Please now click the [accept as solution] and the thumbs up button.
Thank you.