Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi
I'm very new to PowerBi and need some help with the Cumulative Sum Dax formula. I have the following table of Measures created to show Cumulative Sales for current year (Actual), LY and Budget. The data and formula appears correct.
However, when I select a specific Month in the slicer, eg Apr, I get incorrect figures for the cumulative totals.
I'm not sure what is wrong and hope someone can help me with this. I've used the following measure for Sales Actual and YTD Sales Actual:
Solved! Go to Solution.
Hello,
Your cumulative measure should be something like this;
Cumulative Sales Amount = VAR _MaxDate = MAX ( 'Dates'[Date] ) VAR _Result = CALCULATE ( [Sales Actual], 'Calendar'[Date] <= _MaxDate ) RETURN _Result
This is now solved. I changed from ALLSELECTED to ALL.
A similar issued was already solved in attached.
https://community.powerbi.com/t5/Desktop/Slicer-selection-changes-the-cumulative-total/td-p/655657.
I managed to solve this by changing from ALLSELECTED to ALL. My apologies, I should have reviewed existing forum posts more thoroughly. Thanks
This is now solved. I changed from ALLSELECTED to ALL.
A similar issued was already solved in attached.
https://community.powerbi.com/t5/Desktop/Slicer-selection-changes-the-cumulative-total/td-p/655657.
I managed to solve this by changing from ALLSELECTED to ALL. My apologies, I should have reviewed existing forum posts more thoroughly. Thanks
Hello,
Your cumulative measure should be something like this;
Cumulative Sales Amount = VAR _MaxDate = MAX ( 'Dates'[Date] ) VAR _Result = CALCULATE ( [Sales Actual], 'Calendar'[Date] <= _MaxDate ) RETURN _Result
Thank you avendarschildren. I've tried your solution and it has worked!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
42 | |
23 | |
21 | |
16 | |
15 |
User | Count |
---|---|
46 | |
31 | |
30 | |
18 | |
18 |