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 everyone!
I've read a lot of posts on this topic but I am still missing something.
I have created a very simple table called 'Data':
Product | Total Sales |
BA | 1000 |
CWA | 10000 |
DIN | 8000 |
ENC | 2000 |
Then the following calculated colums:
Cumulated = CALCULATE
However the result in Cumulated is the exact same values I have in Total Sales.
What am I missing?
Thank you!
Solved! Go to Solution.
Hi @marcosim ,
If you are making a calculated column for the cumulative you should redo your formula to:
Cumulated = CALCULATE
(
SUM(Data[Total Sales]);
FILTER(ALL(Data);Data[Rank] <= EARLIER(Data[Rank]))
)
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsRefer
https://community.powerbi.com/t5/Desktop/Running-Total-on-a-non-date-column/td-p/44470
https://community.powerbi.com/t5/Desktop/Cumulative-sum-without-date-field/td-p/102967
Also try if this can work
Cumulated = CALCULATE
(
SUM(Data[Total Sales]);
FILTER(ALL(Data[product]);Data[product] <= earlier(Data[product]))
)
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners , HR-Analytics-Active-Employee-Hire-and-Termination-trend
Power-BI-Working-with-Non-Standard-Time-Periods And Comparing-Data-Across-Date-Ranges
Connect on Linkedin
Hi @marcosim ,
If you are making a calculated column for the cumulative you should redo your formula to:
Cumulated = CALCULATE
(
SUM(Data[Total Sales]);
FILTER(ALL(Data);Data[Rank] <= EARLIER(Data[Rank]))
)
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsCovering 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 |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |