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

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

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

6 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    in your Rank function use ALLSELECTED instead of ALL

    • cosminc's avatar
      cosminc
      Post Partisan
      7 years ago

      Hi,

      Rank used is not a function, is in source

      Thanks,

      Cosmin

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Possible to upload some sample data?

  • 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