Forum Discussion

kjartank's avatar
kjartank
Icon for Helper II rankHelper II
9 years ago
Solved

Measure that filters by 10 highest values

I have a table with a column that is used as an identifier. The tables that I make on the two first pages are only supposed to show the 10 highest values from that column, i.e the 10 most recent rows...
  • TheOckieMofo's avatar
    9 years ago

    You might need to post an example of the data so that we can understand exactly what you are looking for. But I think you're looking to rank members of a table by a measure. For example, you're looking to get the top 10 sales reps by total sales? Is that correct?

     

    If so, the easiest way to do this would be to make your table visual in Power BI then look at the "filters" area on the right. Under "Visual Level Filters" there should be the attribute you have in the rows of your table. Hover over this attribute and hit the minus sign. This will display the filter options. From the drop down list, select "Top N" and then under that select the number of items you want to show and the value you want to filter on, usually the same value you are showing in your table.