Cumulative sum measure

Natalia2024 — Thu, 29 Aug 2024 08:47:20 GMT

Hello,

I have the following cumulative sum measure which is built like that:

ArticleRank = RANKX(ALL(vdimarticle_v2),[Calculation KPI],,DESC,Dense)

PercentageofTotal = var TotalKPI = CALCULATE([Calculation KPI],ALL(dimarticle)) RETURN DIVIDE([Calculation KPI],TotalKPI)

CumulativeSumTop102 = var Top10Table = CALCULATETABLE( dimarticle_v2, FILTER( ALL(dimarticle_v2), [ArticleRank]<=30 ) ) var CurrentArticleSum = [PercentageofTotal] RETURN CALCULATE( [PercentageofTotal], FILTER( Top10Table, [PercentageofTotal]>=CurrentArticleSum ) )

It works as follows, it ranks articles based on quantity and then it takes quantity of the first article and divides it by total quatity, for second article, it takes quantity of the first article + quantity of the second article and then divides it by total quantity etc.

But I have problem if I filter sth on table dimarticle, because than measure shows incorrect numbers, do You know how to avoid this situation so allow users filtering on the table and make this cuulativesum be adjusted accordingly to the filters?

Thank you in advance,

Natalia

Re: Cumulative sum measure

Rupak_bi — Thu, 29 Aug 2024 10:04:20 GMT

hi Natalia2024

try to modify you All(table) to AllSelected(table) so that the table works based on your slicers/filters. if still not work, share your dataset with sample data and desired output scenarions.

Re: Cumulative sum measure

Natalia2024 — Mon, 16 Sep 2024 11:31:24 GMT

Thank you so much for the response but ALLSELECTED didn't work in this case, I rewrote this measures a bit differently and now it works.

topic Re: Cumulative sum measure in DAX Commands and Tips

Cumulative sum measure

Re: Cumulative sum measure

Re: Cumulative sum measure