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

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Possible to upload some sample data?

cosminc's avatar
cosminc
Post Partisan
7 years ago

it's a huge base

please try to upload the direct example from the top

Thanks,

Cosmin