Forum Discussion

leeleeds123's avatar
leeleeds123
Frequent Visitor
2 years ago
Solved

Linking My Measure to Multiple Slicers

Hi there,   I have a measure i am using in a visual:   Diff running total in Date = CALCULATE(     SUM('MASTER'[Diff]),     FILTER(         ALLSELECTED(Date_Table_Risk[Date]),         ISONO...
  • rajendraongole1's avatar
    2 years ago

    Hi leeleeds123 -Create a measure as below to correctly work on slicers I am using ALLEXCEPT function can help preserve the necessary context while ignoring other filters that might disrupt the running total calculation.

     

    Measure:

    Diff running total in Date =
    CALCULATE(
    SUM('MASTER'[Diff]),
    FILTER(
    ALLEXCEPT('MASTER', 'MASTER'[Risk Owner]),
    ISONORAFTER('Date_Table_Risk'[Date], MAX('Date_Table_Risk'[Date]), DESC)
    )
    )

     

    Try the above and let know.

    Did I answer your question? Mark my post as a solution! This will help others on the forum!
    Appreciate your Kudos!!