Forum Discussion

Canada321321's avatar
Canada321321
Regular Visitor
9 years ago
Solved

Slicer not interacting with Measure

In the following scenario, does anyone know what changes I need to make to allow the slicer to interact as intended?   Here's an example table. I want to display a sum of year to date amounts, filt...
Need Help
  • Vvelarde's avatar
    Vvelarde
    9 years ago

    Canada321321

     

    Hi, try with this:

     

    YTDRevenue =
CALCULATE (
    SUM ( Sheet1[Amount] ),
    FILTER (
        ALLEXCEPT ( Sheet1, Sheet1[Division] ),
        Sheet1[Date] <= MAX ( Sheet1[Date] )
            && Sheet1[Account] = 4
    )
)
Canada321321's avatar
Canada321321
Regular Visitor
9 years ago

Thanks for all the quick replies, Vvelarde's answer does solve my issue. Phil's answer also works for me, except when there's nothing selected on the slicer, at which point it displays incorrectly. Very much appreciated though!