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.

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.