Forum Discussion

cosminc's avatar
cosminc
Post Partisan
7 years ago
Solved

Evolution Index vs previous value

Hi all   i have a graph calculated with a measure like this   Salesman      Measure        Needed dax expression (divide Measure to previous) George             90%                    blank Ann...
Need Help
  • v-lili6-msft's avatar
    v-lili6-msft
    7 years ago

    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

v-lili6-msft's avatar
v-lili6-msft
Community Support
7 years ago

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's avatar
cosminc
Post Partisan
7 years ago

it works perfect!

Thanks!

Cosmin