Forum Discussion
Helper IIICompare same dimension with two slicers
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!
2 Replies
@@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.
MrMPThank 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?
