Forum Discussion

NeilC's avatar
NeilC
Icon for Advocate I rankAdvocate I
9 years ago
Solved

Measure filtered by slicer

HI all   I have a date slicer that puts a measure into a card (call it Period 1). I have a 2nd date slicer that puts a measure in a 2nd card (call it Period 2). I want a 3rd card which shows the pe...
Need Help
  • Eric_Zhang's avatar
    Eric_Zhang
    9 years ago

    NeilC

    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.

  • NeilC's avatar
    NeilC
    9 years ago

    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.

NeilC's avatar
NeilC
Icon for Advocate I rankAdvocate I
9 years ago

https://drive.google.com/open?id=0B_GOODlRIXtsSTRoN090aVNDMDA

 

Simply, I want to see the percentage difference between the 2 filtered figures (in the Cards)

 

The two figures cover the two selected date ranges, taken from the two sliders. So I want to see the percentage difference between card 2 and card 1. 

 

Thanks

Eric_Zhang's avatar
Eric_Zhang
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

NeilC

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.

  • NeilC's avatar
    NeilC
    Icon for Advocate I rankAdvocate I
    9 years ago

    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.