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
    )
)
dkay84_PowerBI's avatar
dkay84_PowerBI
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Try changing your ALL(Sheet1) to specify ALL(Sheet1[Date]) or ALL(Sheet1[Account]) for the second part.

 

Your measure effectively overrides the filter context of Division because your ALL argument indicates the entire table.

  • Vvelarde's avatar
    Vvelarde
    Icon for Community Champion rankCommunity Champion
    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
    )
)