Forum Discussion
JamesBurke
2 years agoHelper III
Top N
Hi all , I want a measure that returns the value that is in 2 in the top N Value Topn =
CALCULATE(MAXX('Emporia Devices', 'Emporia Devices'[Device name KP]),FILTER(TOPN(
...
- 2 years ago
JamesBurke , Try to use the index function for that
Continue to explore Power BI Index function: Top/Bottom Performer by name and value- https://youtu.be/HPhzzCwe10U
Find Top & Bottom Performers| How to get 2nd Topper without Rank-Filter
https://www.youtube.com/watch?v=vipvw4F8LcE&list=PLPaNVDMhUXGZ5uQZ_v0tfC5lIjEHoa6Yk
amitchandak
2 years agoSuper User
JamesBurke , Try to use the index function for that
Continue to explore Power BI Index function: Top/Bottom Performer by name and value- https://youtu.be/HPhzzCwe10U
Find Top & Bottom Performers| How to get 2nd Topper without Rank-Filter
https://www.youtube.com/watch?v=vipvw4F8LcE&list=PLPaNVDMhUXGZ5uQZ_v0tfC5lIjEHoa6Yk