Forum Discussion

MrMP's avatar
MrMP
Icon for Helper III rankHelper III
5 years ago

Compare 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 wi...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

@@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's avatar
    MrMP
    Icon for Helper III rankHelper III
    5 years ago

    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?