Show only Top 10 in Table - Constrain list with DAX

[irnm8dn]

I have a series of datasets which ranks salespeople by performance.  The rank is not determined by through a calculation.

Within the table, I only want to display the rank of the Top 10, in order.

Need some help with a DAX statment so the table will be constrained to only show the Top 10.

Thanks!

[v-juanli-msft]

Hi @irnm8dn

---

  The rank is not determined by through a calculation. 

If the rank column comes from the original data source and don't need to calculate to get this result, since you want to only show top10 rank in the table visual, you can add this column to the Visual Filter and select "is less than or equal to 10".

Then the table would only show top10 rank.

Best Regards

Maggie

[irnm8dn]

@v-juanli-msft

That's an interesting application of a visual filter.  What about if I specifically wanted to limit the data (with no risk of the user changing it)?

[Anonymous]

Hi

If possible, could you please share a sample data set with expected result ?

Thanks
Raj

[irnm8dn]

@Anonymous

Please see this link for a sample file.

The PBI output will limit the table to show only the Top 10 by %.

Thanks!