How to only show TOP N in table

The solutions I know are:

  1. Use RANK calculation, then inserting a filter
  2. Create a new table in dax using the TOPN function

NewTable = TOPN(100, YourTable
               , YourTable[ColumnToOrder]
               , DESC)

CLICK HERE to find out more related problems solutions.

Leave a Comment

Your email address will not be published.

Scroll to Top