Top 10

[sks2701]

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 clients wants to see the Top 10 Co. by Revenue Range

Revenue Range

> $1B

$500M - $1B

$250M - $500M

$100M - $250M

$50M - $100M

$25M - $50M

$10M - $25M

$5M - $10M

$1M - $5M

$100K - $1M

N/A

[v-janeyg-msft · Accepted solution]

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.

[sks2701]

thank you

[camargos88]

@sks2701 ,

This link can help you:

https://www.daxpatterns.com/dynamic-segmentation/#

[Bohumil_Uhrin]

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.