Forum Discussion
Advocate IMeasure filtered by slicer
In this case, I think you'll have to duplicate the table and apply slicers to those two tables and calculate the difference via a measure like
diff = SUM(Table2[Calls])-SUM(duplicateTable2[Calls])
Check more details in the attached pbix.
Thanks for the replies.
This will work. I can get a one on one comparison using this menthod. Not sure when I want to compare 10. Dont really want 10 duplicate tables ;-)
Maybe Im trying to use Power BI in ways its not really designed for. I really thought there would be a very simple solution, but hours of searching have drawn a blank (for a working solution). I can do this in about 1 min in Excel :-(
Really appreicate the help. Thanks.
Microsoft EmployeeIn this case, I think you'll have to duplicate the table and apply slicers to those two tables and calculate the difference via a measure like
diff = SUM(Table2[Calls])-SUM(duplicateTable2[Calls])
Check more details in the attached pbix.
Advocate IThanks for the replies.
This will work. I can get a one on one comparison using this menthod. Not sure when I want to compare 10. Dont really want 10 duplicate tables ;-)
Maybe Im trying to use Power BI in ways its not really designed for. I really thought there would be a very simple solution, but hours of searching have drawn a blank (for a working solution). I can do this in about 1 min in Excel :-(
Really appreicate the help. Thanks.