Evolution Index vs previous value

[cosminc]

Hi all

i have a graph calculated with a measure like this

Salesman      Measure        Needed dax expression (divide Measure to previous)

George             90%                    blank

Anna                 30%                      33% (divide 30%/90%)

John                 20%                      66%  (divide 20%/30%)

Michael            10%                      50% (divide 10%/20%)

The Salesmen have associated a rank behing and are sorted after it; but not all salesmen are selected so the rank is not consecutive

George  5

Anna     6

John     9

Michael  10

Thanks,

Cosmin

[v-lili6-msft · Accepted solution]

HI, @cosminc 

Just try this formula to create a measure

Result = VAR _LASTRANK=CALCULATE(MAX('Table'[rank]),FILTER(ALLSELECTED('Table'),'Table'[rank]<MAX('Table'[rank])) ) RETURN
DIVIDE([Measure],CALCULATE([Measure],FILTER(ALLSELECTED('Table'),'Table'[rank]=_LASTRANK)))

Result:

here is pbix file, please try it.

Best Regards,

Lin

[cosminc]

it works perfect!

Thanks!

Cosmin

[Anonymous]

in your Rank function use ALLSELECTED instead of ALL

[cosminc]

Hi,

Rank used is not a function, is in source

Thanks,

Cosmin

[Anonymous]

Possible to upload some sample data?

[cosminc]

it's a huge base

please try to upload the direct example from the top

Thanks,

Cosmin