Forum Discussion

avelio's avatar
avelio
Icon for Helper II rankHelper II
8 years ago
Solved

Prior Year Sales Data does not work when applying more then one filter.

Dears,   Please advise on the issue below.   I have created 3 measures in order to display the % change of sales when selecting a year and it goes like this:   1) I've created a measure to calc...
Need Help
  • mattbrice's avatar
    mattbrice
    8 years ago

    In your CALCULATE function call, the “ALL(‘to’)” is blocking the filter on Brand.  From what I see it should be removed.  

mattbrice's avatar
mattbrice
Icon for Solution Sage rankSolution Sage
8 years ago

In your CALCULATE function call, the “ALL(‘to’)” is blocking the filter on Brand.  From what I see it should be removed.  

  • avelio's avatar
    avelio
    Icon for Helper II rankHelper II
    8 years ago

    Hi Matt,

     

    Thanks for your reply.

    Tried removing it, still having the same result.

     

    thanks

  • avelio's avatar
    avelio
    Icon for Helper II rankHelper II
    8 years ago

    On second thought, it works.

    My mistake!

     

    thanks a lot!