- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Linking My Measure to Multiple Slicers
Hi there,
I have a measure i am using in a visual:
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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!!
Proud to be a Super User! | |
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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!!
Proud to be a Super User! | |

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
08-06-2024 06:24 AM | |||
09-17-2024 11:15 PM | |||
08-29-2024 12:56 AM | |||
08-15-2024 11:33 AM | |||
09-18-2024 07:33 AM |
User | Count |
---|---|
86 | |
82 | |
42 | |
40 | |
35 |