Reply
leeleeds123
Frequent Visitor
Partially syndicated - Outbound

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]),
        ISONORAFTER('Date_Table_Risk'[Date], MAX('Date_Table_Risk'[Date]), DESC)
    )
)
 
This measures works fine in my visual, however when i use my slicer to filter by different teams for example i get the wrong results in my visual. I have been trying to incorporate allexcept into the measure with limited success.
 
For ref the table i am trying to link it to is called 'Master' and the column is called 'Risk Owner'.
 
Thank you in advance. 
1 ACCEPTED SOLUTION
rajendraongole1
Super User
Super User

Syndicated - Outbound

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!!





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





View solution in original post

1 REPLY 1
rajendraongole1
Super User
Super User

Syndicated - Outbound

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!!





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





avatar user

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

Check out the February 2025 Power BI update to learn about new features.

Feb2025 NL Carousel

Fabric Community Update - February 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)