cancel
Showing results for
Did you mean:
Highlighted
Member

## 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

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team

## Re: Evolution Index vs previous value

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

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
6 REPLIES 6
Super User

Member

## Re: Evolution Index vs previous value

Hi,

Rank used is not a function, is in source

Thanks,

Cosmin

Super User

## Re: Evolution Index vs previous value

Possible to upload some sample data?

Member

## Re: Evolution Index vs previous value

it's a huge base

Thanks,

Cosmin

Community Support Team

## Re: Evolution Index vs previous value

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

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Member

## Re: Evolution Index vs previous value

it works perfect!

Thanks!

Cosmin

Announcements

#### Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

#### Community News & Announcements

Get your latest community news and announcements.

#### Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

#### Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Top Kudoed Authors
Users Online
Currently online: 52 members 1,346 guests
Recent signins: