Cumulative total for pareto

[marcosim]

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:

Rank = RANKX(Data;Data[Total Sales])

Cumulated = CALCULATE

(

SUM(Data[Total Sales]);

FILTER(ALL(Data[Rank]);Data[Rank] <= MAX(Data[Rank]))

)

However the result in Cumulated is the exact same values I have in Total Sales.

What am I missing?

Thank you!

[amitchandak]

Refer

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

[MFelix · Accepted 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]))
)

[VasTg]

@marcosim 

You should use ALL(TABLE) instead of just the column.

Measure = CALCULATE(SUM('Table'[Total Sales]),FILTER(ALL('Table'),'Table'[Rank]<=MAX('Table'[Rank])))

Read about "Context transition" in Calculate.

If it helps, mark it as a solution

Kudos are nice too.