Forum Discussion

alextarki's avatar
alextarki
Helper I
6 years ago
Solved

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 hardcode...
Need Help
  • v-deddai1-msft's avatar
    v-deddai1-msft
    6 years ago

    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

alextarki's avatar
alextarki
Helper I
6 years ago

 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

v-deddai1-msft's avatar
v-deddai1-msft
Community Support
6 years ago

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