Forum Discussion
Solved
Comparing 2 Nested Slicers in a Table
Is there an easy way to compare the 2 nested slicers? Example1: Select: Slicer1 - Parent2, Group1, Type3 and Type4 Select: Slicer2 – Parent1, Group2 (Selecting all types in Group2) Slicer1 = 5 S...
I was able to find the solution here. Thanks for you help
https://community.powerbi.com/t5/Desktop/Two-slicer-on-same-column/m-p/516318/thread-id/241351
Hi， Walt
You need to copy a new table and filter the data separately by these two slicers to compare the results.
Result =
SUM ( 'Table1'[value] ) / SUM ( 'Table2'[value] )
Best Regards,
Community Support Team _ Eason