Forum Discussion
Solved
Chart for Top N + Others
My data has thousands of unique rows where each row has a category to it.
Example table:
| Date | Order No | Category |
| 01/01/2020 | 1122 | Computer |
| 01/02/2020 | 1133 | Table |
| 14/02/2020 | 1143 | Sofa |
| 14/03/2020 | 1155 | Computer |
How do I show the top 1 (for example) with others.
So in this case,
Top 1: Computer (2 no.)
Others: Others (2 no.)
Hi readyraddy ,
Check the following measures.
Measure = CALCULATE(COUNT('Table'[Order No]),(ALLEXCEPT('Table','Table'[Category]))) Measure 2 = RANKX(ALLSELECTED('Table'),[Measure],,DESC,Dense) Measure 3 = IF([Measure 2]=1,"top1","others")Result would be shown as below.
Best Regards,
jay
3 Replies
readyraddy , Refer if this can help
I've already watched the video but I think it won't be possible as there isnt any numerical value in the rows to rank the entire table.
Hi readyraddy ,
Check the following measures.
Measure = CALCULATE(COUNT('Table'[Order No]),(ALLEXCEPT('Table','Table'[Category]))) Measure 2 = RANKX(ALLSELECTED('Table'),[Measure],,DESC,Dense) Measure 3 = IF([Measure 2]=1,"top1","others")Result would be shown as below.
Best Regards,
jay
