Forum Discussion
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 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 |
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.
4 Replies
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.
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.
thank you
