Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi All,
I have velow data. I want to get the name of that student who have shown hightest increase in his 4th test as compared to 1st test. I also want to know the % of increase achieved by that student by comparing 1st test score & 4th test score.
Thanks in advance.
Student name | Test | Score |
A | 1 | 50 |
A | 2 | 40 |
A | 3 | 90 |
A | 4 | 70 |
B | 1 | 30 |
B | 2 | 20 |
B | 3 | 50 |
B | 4 | 95 |
C | 1 | 30 |
C | 2 | 40 |
C | 3 | 50 |
C | 4 | 60 |
D | 1 | 80 |
D | 2 | 40 |
D | 3 | 70 |
D | 4 | 60 |
E | 1 | 50 |
E | 2 | 20 |
E | 3 | 90 |
E | 4 | 80 |
Solved! Go to Solution.
@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
✨ Follow us on LinkedIn
Learn about conditional formatting at Microsoft Reactor
My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Hi, @harshadrokade
Check this:
Did I answer your question? Please Like and Mark my post as a solution if it solves your issue. Thanks.
Appreciate your Kudos !!!
https://www.youtube.com/channel/UCndD_QZVNB_JWYLEmP6KrpA
Proud to be a Super User!
Hi,
Please check the below picture and the attached pbix file.
All measures are in the attached pbix file.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
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.
Learn about conditional formatting at Microsoft Reactor
My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
@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.
Learn about conditional formatting at Microsoft Reactor
My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
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-
Hi,
Please check the below picture and the attached pbix file.
All measures are in the attached pbix file.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Hi, @harshadrokade
Check this:
Did I answer your question? Please Like and Mark my post as a solution if it solves your issue. Thanks.
Appreciate your Kudos !!!
https://www.youtube.com/channel/UCndD_QZVNB_JWYLEmP6KrpA
Proud to be a Super User!
@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
✨ Follow us on LinkedIn
Learn about conditional formatting at Microsoft Reactor
My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
User | Count |
---|---|
93 | |
84 | |
78 | |
75 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
60 |