Forum Discussion

sks2701's avatar
sks2701
Helper III
5 years ago
Solved

Top 10

Hi Team I have a data set which has column with revenue detail and I have added a custom column for Revenue range as below : My question is how can we show this in the power bi visuals, if my clien...
Need Help
  • v-janeyg-msft's avatar
    v-janeyg-msft
    5 years ago

    Hi, sks2701 

     

    It’s my pleasure to answer for you.

    According to your description,I think you can create a measure, then use it in filter pane.

    Like this:

    Measure =
VAR tab =
    TOPN (
        10,
        CALCULATETABLE (
            DISTINCT ( 'Table1'[value] ),
            FILTER ( ALL ( Table1 ), [Range] = MAX ( Table1[range] ) )
        ),
        [Value]
    )
RETURN
    IF ( MAX ( Table1[value] ) IN tab, 1, 0 )

    Here is my sample .pbix file.Hope it helps.

    If it doesn’t solve your problem, please feel free to ask me.

     

    Best Regards

    Janey Guo

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Bohumil_Uhrin's avatar
Bohumil_Uhrin
Helper II
5 years ago

Why top10 by "range"? And not by actual revenue?

There could be many customers, lets say 30, in one range. How would you deal with that? Best is top10 by revenues, I dont see logic behind what youre trying to do.