Forum Discussion
Solved
RANKX: using aggregate functions on the expression
I have the following data on ID and Type: ID Type Type TopN Ranking 1 A A 1 2 B B 2 3 C Others 3 4 A A 1 5 A A 1 6 B B 2 7 C Others 3 8 D Others ...
Hi, bleow
To create 2 column with this:
_RankColumn = RANKX ( 'Table', CALCULATE ( COUNT ( [Type] ), ALLEXCEPT ( 'Table', 'Table'[Type] ) ), , DESC, DENSE )_TopN = IF ( 'Table'[_RankColumn] <= 3, [Type], "Others" )Result:
Please refer to the attachment below for details
For references:
Hope this helps.
Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
bleow , You can try measure like
RANKX(
table,
calculate(COUNT(table[Type])), ,
DESC,
Dense
)
if you are using above measure then this should also be measure
RETURN IF(
Ranking<=3,
[Type],
"OTHERS"
)
or consider top N
TOPN: https://www.youtube.com/watch?v=QIVEFp-QiOk&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=42