Getting highest increase in test score

harshadrokade add following measure to achieve it:

Sum Score = SUM ( Score[Score] )

Score Diff = 
VAR __score1st = CALCULATE ( [Sum Score], Score[Test] = 1 )
VAR __score4th = CALCULATE ( [Sum Score], Score[Test] = 4 )
VAR __diff = __score4th - __score1st
RETURN
DIVIDE ( __diff, __score1st )

Student Rank = RANKX ( ALLSELECTED ( Score[Student name] ), [Score Diff], , DESC ) 

and here it the output, tweak it as you see fit

Hi, harshadrokade 

Check this:

https://www.dropbox.com/s/qvygfk6v6mev9rg/Getting%20highest%20increase%20in%20test%20score%20%28allure-analytics.com%29.pbix?dl=0

Did I answer your question? Please Like and Mark my post as a solution if it solves your issue. Thanks.

Appreciate your Kudos !!!

https://allure-analytics.com/

https://www.youtube.com/channel/UCndD_QZVNB_JWYLEmP6KrpA

Hi,

Please check the below picture and the attached pbix file.

All measures are in the attached pbix file.

Hi Jihwan_Kim ALLUREAN parry2k 

With all of your help, I could create the measure that gives me the % of the increase/decrease in test 4 over test 1. 

When I put that measure in a table against the Student name, it gives the correct % increase/decrease however when I am trying to get the top student name out of that measure, it is giving me only top first student name correctly but when I try to find top second student name, it gives me the top first student name only.

I am using below measure to get the top 1st which is working well-

harshadrokade your original question was asked and a solution was provided. The new question you asked is something totally different and the solution I provided is not suitable for it. You should accept a solution on this thread and create a new post for the 2nd question.