How to compare data from multiple slicers with different tables

[budhie]

Hi,

I am new to PowerBI and need some help from the experts here.

I have a model similar to below:

And I am trying to get the result as shown below, which can show the result based on the conditions that I select on the left slicers, compared to the result based on the conditions that I select on the right slicers. 

I can solve this issue by duplicating the model into 2, but I feel the dashboard becomes so heavy. Is there any way to do it efficiently without duplicating the model using DAX formula?

Any helps are appreciated. Thank you!

[speedramps]

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.

[budhie]

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 

[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.

[speedramps · Accepted solution]

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.

Click here to download PBIX 

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.

[budhie]

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?