https://community.fabric.microsoft.com/t5/s/yrjkf47658/tracker owenmillerUK Tracker Fri, 18 Sep 2026 22:52:05 GMT 2026-09-18T22:52:05Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Top-3-of-scores/m-p/3079625#M107256 <P>Thanks&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="443516" data-lia-user-login="ppm1" class="lia-mention lia-mention-user">ppm1</a>&nbsp;- 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?</P> Tue, 14 Feb 2023 14:01:25 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Top-3-of-scores/m-p/3079625#M107256 owenmillerUK 2023-02-14T14:01:25Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Top-3-of-scores/m-p/3079566#M107245 <P>Hello,<BR />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.&nbsp;<BR />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?<BR />Thanks in advance!</P> Tue, 14 Feb 2023 13:33:38 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Top-3-of-scores/m-p/3079566#M107245 owenmillerUK 2023-02-14T13:33:38Z