Reply
bi_team_ru2
Frequent Visitor

power bi abc with cumulative total

good noon!

 

2.gif

i need take the cumulative total from the  Measure SHARE (desc)

but, then i`m create a new measure Ranking with formula

Ranking = CALCULATE(('Test'[Share]);ALLEXCEPT(Test;Test[Client];Test[Manager]);Test[CSumMon]>=EARLIER(Test[CSumMon]))

the power bi said:

EARLIER / EARLIEST refers to an earlier line context, which does not exist.

and then i`m changed measure to a column, in the result i see the count of element any sorting

 

how do , then Measure summing with cumulative total?

or how do, then in column i have the share of any elements?

sens yours

1 ACCEPTED SOLUTION
bi_team_ru2
Frequent Visitor

MPop = sum(Population[Population])

MTotalPop = CALCULATE(SUMX('Population';'Population'[Population]);ALLSELECTED('Population'))

MPopCumul1 = CALCULATE('Population'[MPop];FILTER(ALLselected('Population');'Population'[MPop]>=MAXx('Population';'Population'[MPop])))

and Measure Share
MShare = DIVIDE('Population'[MPop];'Population'[MTotalPop]) 

MShareCumul1 = CALCULATE('Population'[MPopCumul1]/'Population'[MTotalPop])

and Measure ABC
МABC = if(DIVIDE('Population'[MPopCumul];'Population'[MTotalPop]) <=0,7;"A";if(DIVIDE('Population'[MPopCumul];'Population'[MTotalPop]) <=0,9;"B"; "C"))

View solution in original post

1 REPLY 1
bi_team_ru2
Frequent Visitor

MPop = sum(Population[Population])

MTotalPop = CALCULATE(SUMX('Population';'Population'[Population]);ALLSELECTED('Population'))

MPopCumul1 = CALCULATE('Population'[MPop];FILTER(ALLselected('Population');'Population'[MPop]>=MAXx('Population';'Population'[MPop])))

and Measure Share
MShare = DIVIDE('Population'[MPop];'Population'[MTotalPop]) 

MShareCumul1 = CALCULATE('Population'[MPopCumul1]/'Population'[MTotalPop])

and Measure ABC
МABC = if(DIVIDE('Population'[MPopCumul];'Population'[MTotalPop]) <=0,7;"A";if(DIVIDE('Population'[MPopCumul];'Population'[MTotalPop]) <=0,9;"B"; "C"))
avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Kudoed Authors (Last Month)