cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
cosminc Member
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
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:

3.JPG4.JPG

 

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.

View solution in original post

6 REPLIES 6
Super User
Super User

Re: Evolution Index vs previous value

in your Rank function use ALLSELECTED instead of ALL

cosminc Member
Member

Re: Evolution Index vs previous value

Hi,

Rank used is not a function, is in source

Thanks,

Cosmin

Super User
Super User

Re: Evolution Index vs previous value

Possible to upload some sample data?

cosminc Member
Member

Re: Evolution Index vs previous value

it's a huge base

please try to upload the direct example from the top

Thanks,

Cosmin

 

Community Support Team
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:

3.JPG4.JPG

 

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.

View solution in original post

cosminc Member
Member

Re: Evolution Index vs previous value

it works perfect!

Thanks!

Cosmin

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

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

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

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.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

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

Users Online
Currently online: 52 members 1,346 guests
Please welcome our newest community members: