Forum Discussion

EpicTriffid's avatar
EpicTriffid
Icon for Helper IV rankHelper IV
1 year ago

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 ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi, EpicTriffid 

 

Rank = RANKX(ALL('Table'),CALCULATE(SUM('Table'[2023]),ALLSELECTED('Table'[Provider name 2023],'Table'[Course name])),,DESC)

Is this the result you were hoping for? If not, can you provide example data and a description of your desired output?

 

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.