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 ...
Hi EpicTriffid This is my data. I want to find top 15 CS names by # of orders. To find rank try below code:
Rank =
RANKX(
ALLSELECTED('CS Data'),
[# of Order],
,
DESC,
DENSE
)
To filter out only top 15, try below code:
Top 15 =
IF([Rank] <= 15, 1, BLANK())
Now use this measure in filter this visual option. See image below:
Here is the top 15. Now you can filter using any dimension.
Hope this helps!!
If this solved you problem, please accept it as a solution!!
Best Regards,
Shahariar Hafiz
Sorry. Thankyou for the suggestion but the result in the same
