Forum Discussion
Top 15 Values
Hi all, I'm really beginning to lose my rag with RANKX and TOPN, or at least in trying to work out what I'm doing. I want to be able to isolate the top 15 rows in my table, including the top ...
1- Create a Measure to sum your 2023 column
SumOf2023Column =
SUM(
'54'[2023]
)
2- Create Other Measure to rank your table
Ranking=
RANKX(
ALL('54'[Course name],
[SumOf2023Column] , ,
DESC,
Skip
)