Forum Discussion
Table TopN and Fixed value
Hi
As per the table below I want to bring in a company that isnt in the Top 10, and I have be a fixed value in my table. So even if filters are applies and the Top10 changes this company will still be in the table to act as a comparison.
Hi lak788 ,
I created some data:
“company that isn’t in the Top 10” : N
Here are the steps you can follow：
1. Create measure.
Rank = RANKX(ALL('Table'),CALCULATE(SUM('Table'[Revenue])),,DESC)Flag = IF( [Rank]<=10 || MAX('Table'[Company])="N",1,0)2. Place [Flag]in Filters, set is=1, apply filter.
3. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
2 Replies
lak788 I did something along these lines using a Complex Selector: https://community.powerbi.com/t5/Quick-Measures-Gallery/The-Complex-Selector/m-p/1116633#M534
Hi lak788 ,
I created some data:
“company that isn’t in the Top 10” : N
Here are the steps you can follow：
1. Create measure.
Rank = RANKX(ALL('Table'),CALCULATE(SUM('Table'[Revenue])),,DESC)Flag = IF( [Rank]<=10 || MAX('Table'[Company])="N",1,0)2. Place [Flag]in Filters, set is=1, apply filter.
3. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
