Forum Discussion
Dynamic TOP N list
Hi alextarki ,
>>The filter should be by company rather then by sales measure
Do you mean to show the data of the top n companies. And you need to add an index column for it:
Create a topn table for slicer:
Create a measure for filter on the visual:
Measure = VAR N = IF ( HASONEVALUE ( 'TopN'[top] ), SELECTEDVALUE ( 'TopN'[top] ), 3 ) RETURN IF ( MAX ( SALES[Index] ) < N, 1, 0 )For more details ,please refer to https://community.powerbi.com/t5/Desktop/Dynamic-TopN-reports-in-Power-BI/td-p/122091
Best Regards,
Dedmon Dai
| Company | Sales |
| A | 100 |
| B | 150 |
| C | 200 |
| D | 250 |
| E | 300 |
| F | 350 |
| G | 400 |
salesmeasure = SUM(SalesTable[Sales])
create a what-if parameter
Create a DAX measure
Status =
var _rank=CALCULATE(RANKX(ALL(SalesTable),SalesTable[salesmeasure],,DESC,Dense))
var _result= IF(Parameter[Parameter Value]>=_rank,"show","hide")
return _result
You can use the above measure in the visual level filter.
Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂
Thanks
The filter should be by company rather then by sales measure
IF I select 30 then filter should deliver the list of 30 companies
alextarki What is the logic for getting the 30 companies?
Hi alextarki ,
>>The filter should be by company rather then by sales measure
Do you mean to show the data of the top n companies. And you need to add an index column for it:
Create a topn table for slicer:
Create a measure for filter on the visual:
Measure = VAR N = IF ( HASONEVALUE ( 'TopN'[top] ), SELECTEDVALUE ( 'TopN'[top] ), 3 ) RETURN IF ( MAX ( SALES[Index] ) < N, 1, 0 )For more details ,please refer to https://community.powerbi.com/t5/Desktop/Dynamic-TopN-reports-in-Power-BI/td-p/122091
Best Regards,
Dedmon Dai
