Show top N rows in table that change when you select a column

[Anonymous]

I would like to only show the topN rows in the table below. However,  I need to be able to sort by the column headings to bring each of the different measures to the top. Any way that I can do this??

[v-xuding-msft · Accepted solution]

Hi @Anonymous , 

I created a sample you can have a try.

1.create a irrelative table as a slicer .

2. create a measure and put it into the fields of Filter in this visual.

Top N = 
VAR se =SELECTEDVALUE ( 'Table'[Column1])
RETURN
 SWITCH( TRUE(),
 se = "Net_sales",
 COUNTROWS(FILTER(ALL('Table1'),ISONORAFTER('Table1'[Net_sales],SELECTEDVALUE('Table1'[Net_sales]),DESC,'Table1'[Customer_No],SELECTEDVALUE('Table1'[Customer_No]),DESC))),
 se = "Controlled_sales",
COUNTROWS(FILTER(ALL('Table1'),ISONORAFTER('Table1'[Controlled_sales],SELECTEDVALUE('Table1'[Controlled_sales]),DESC,'Table1'[Customer_No],SELECTEDVALUE('Table1'[Customer_No]),DESC))),
 se = "Units",
COUNTROWS(FILTER(ALL('Table1'),ISONORAFTER('Table1'[Units],SELECTEDVALUE('Table1'[Units]),DESC,'Table1'[Customer_No],SELECTEDVALUE('Table1'[Customer_No]),DESC))),
 se = "Controlled_Unites",
COUNTROWS(FILTER(ALL('Table1'),ISONORAFTER('Table1'[Controlled_Unites],SELECTEDVALUE('Table1'[Controlled_Unites]),DESC,'Table1'[Customer_No],SELECTEDVALUE('Table1'[Customer_No]),DESC))),
 BLANK()
 )

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.