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

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!