Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
HemanthV
Helper II
Helper II

ALL function is not working for multiselection on another slicer

Hello Guys,

 

I have some columns like Fiscal Period, Stage and Amount.

I want amount, only for P5: Won and i don't want Stage Slicer to work for the measure, so i have written a measure like:

P5 Won = CALCULATE( SUM(Sheet1[Amount]) ,
Sheet1[Stage] = "P5: Won",
All(Sheet1[Stage])
)
Now if i select only one fiscal period, measure is working as expected and stage slicer is not impacting the value.
HemanthV_0-1656400579373.png  HemanthV_1-1656400613730.png

 

But if i select multiple Fiscal Periods then measure is not working as expected, Stage Slicer is now impacting the value. Please see below screenshots

HemanthV_2-1656400720603.png  HemanthV_3-1656400743472.png

 

Amount for 2022 is 9M but Stage filter is impacting value even it is in ALL function.

 

Please help me on this!

Thanks in advance!

 

@parry2k @amitchandak 

 

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@HemanthV , try if one of the 2 can help

 

P5 Won = CALCULATE( SUM(Sheet1[Amount]) ,
filter(All(Sheet1[Stage]) ,Sheet1[Stage] = "P5: Won")
)

 

P5 Won = CALCULATE( SUM(Sheet1[Amount]) ,
Sheet1[Stage] = "P5: Won"
)

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here

View solution in original post

1 REPLY 1
amitchandak
Super User
Super User

@HemanthV , try if one of the 2 can help

 

P5 Won = CALCULATE( SUM(Sheet1[Amount]) ,
filter(All(Sheet1[Stage]) ,Sheet1[Stage] = "P5: Won")
)

 

P5 Won = CALCULATE( SUM(Sheet1[Amount]) ,
Sheet1[Stage] = "P5: Won"
)

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here

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!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

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