Forum Discussion

readyraddy's avatar
readyraddy
Icon for Helper I rankHelper I
5 years ago
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 ...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    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

readyraddy's avatar
readyraddy
Icon for Helper I rankHelper I
5 years ago

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.