Forum Discussion
Linking My Measure to Multiple Slicers
- 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!!
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!!