Compare same dimension with two slicers

[MrMP]

Hi All,

I have the following table:

Dimension1	Amount
AA	10
AA1	20
AA1	15
AA2	50

Then I have to create 3 cards.

One slicer should filter one card, second slicer will filter second card and then difference in third card.

Example:

So lets say you want to compare AA vs AA1 but you have to pick them from two different slicers. 

Cards will show the following:

Card 1 = 10

Card 2 =  35

Card 3 = -25

Thank you for your help!

[Anonymous]

@@MrM 

You can use edit interaction to make the visuals filter as expected, but if you want to also calculate the difference, you must create another disconnect table, then create 3 card measures. Check the pbix for detail.

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

[MrMP]

Thank you for your solution!

The original model size is really huge (50+ Mil rows). Can duplicate table create a problem, double the size of the model?