Forum Discussion

floralau's avatar
floralau
New Member
4 years ago
Solved

doughnut chart: top 3

What I have now is a doughnut chart with mainly two colors(i.e red and blue) and more than 10 values. and i would like to show the top 3 values of each color. or either to only show top 3 value's lab...
Need Help
  • PC2790's avatar
    PC2790
    4 years ago

    See if this helps:

    Measureabcd =
SUMX (
    TOPN (
        3,
        SUMMARIZE (
            ChannelTable,
            ChannelTable[Channel],
            "abcd", COUNT ( ChannelTable[Channel] )
        ),
        [abcd], DESC
    ),
    COUNT ( ChannelTable[Channel] )
)

     

PC2790's avatar
PC2790
Icon for Community Champion rankCommunity Champion
4 years ago

on what criteria you are basing your top three value?

I can give you an example, suppose I want the top three based on the sum of the amounts across each country. I'll use:

Top3 = sumx(TOPN(3,SUMMARIZE(CCY,CCY[CY],"abcd",SUM(CCY[Amount_in_USD])),[abcd],DESC),[abcd])

You can try to mould it according to your requirement.Or provide with more details on the dataset so that we cna help you with it

floralau's avatar
floralau
New Member
4 years ago

My [Channel] column is somethings like "aaa","aaa","bbb","ccc""ccc", "ddd","ddd","ddd","eee".

I would like to count them, and rank by the number of appearances.

 

Thank a lot for answering!

  • PC2790's avatar
    PC2790
    Icon for Community Champion rankCommunity Champion
    4 years ago

    See if this helps:

    Measureabcd =
SUMX (
    TOPN (
        3,
        SUMMARIZE (
            ChannelTable,
            ChannelTable[Channel],
            "abcd", COUNT ( ChannelTable[Channel] )
        ),
        [abcd], DESC
    ),
    COUNT ( ChannelTable[Channel] )
)

     

    • floralau's avatar
      floralau
      New Member
      4 years ago

      Thanks so much for helping!