cancel
Showing results 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

Frequent Visitor

## power bi abc with cumulative total

good noon!

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