Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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"))

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors
Top Kudoed Authors