Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon'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.
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:
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
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!
Solved! Go to Solution.
@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"
)
@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"
)
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
124 | |
79 | |
50 | |
38 | |
38 |
User | Count |
---|---|
195 | |
80 | |
70 | |
51 | |
42 |