how to show top 50 records in a table in power bi contains columns and measures and slicers

[sridharbabu]

in power bi having partno,location,bu slicers and table with partno,location,measure1,measure2,measure3. measure3 in ascending order. How to show top 50 records based on measure3. andto add serial number for those records. 1 to 50. how to achieve this. used rankx, of having duplicate partno and measure3 showing same number for the records, any other alternate method to show 1 to 50. irrespective of duplicate partno and measure3.

[Anonymous · Accepted solution]

= SUMX(
    TOPN( 10,
      SUMMARIZE( TableName, TableName[partno], <nextcolumn>, <nextColumn>, etc.
    "TotalSales", SUM(TableName[Value]) ), [TotalVaule], DESC ), [TotalValue]
)