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] )
)

     

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
Community 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!