Top 3% of scores

[owenmillerUK]

Hello,
I have a table of people, which includes a "score" that exists as a measure. I have been asked to show only the top 3% of people by score, and only show these individuals in the table. 
I am aware of the "Top N" filter that can be placed upon the table, but unsure how to get this working with the top % rather than top number of people?
Thanks in advance!

[owenmillerUK]

Thanks @ppm1 - I've just tried that and in a card visual it returns a number, which I believe is the number of people who are in that top 3%. However, I also want to filter my table down so that only the individuals who are in that top 3% are shown. When I try and add the measure into the table it fails to display. How could I achieve that?

[smpa01]

@owenmillerUK pls provide sample data and expected output

[ppm1]

Here's an example that shows one way to do it. Works in a visual with just the products. You could adapt for students.

Top 3% Products =
VAR pct3 =
    ROUNDUP ( COUNTROWS ( ALLSELECTED ( Products[Product] ) ) * 0.03, 0 )
VAR top3pct =
    TOPN ( pct3, ALLSELECTED ( Products[Product] ), [Total Sales], DESC )
RETURN
    CALCULATE ( [Total Sales], KEEPFILTERS ( top3pct ) )

Pat

[ppm1]

Can you explain your model further? In my case, I have a Product dimension and a Sales fact table (used in the Total Sales measure). When I create a table visual with the Product column (from the Product table), I get the following with that measure. All the products not in the top 3% return blank and are filtered out by the visual.

Pat