Forum Discussion
Dynamic TOP N list
HI
I have investigated multiple demos and didnt find the answer for the following question :
Top N - How to enter dynamicly select the list of the first N records as the filter TOPN is hardcoded to an individual value
Select TOP N : 5 10 20
Company Sales
A 100
B 50
C 30
D 5
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
6 Replies
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 _resultYou 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?
Refer to this similar post https://community.powerbi.com/t5/Desktop/Top-n-Filter-with-Dynamic-fields/m-p/901378
Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂Unfortunately, this topic is not related to my point I need dynamic list of value : I select TOP 10 it shows 10 records ,
I select TOP 20 - it shows 20 records
