Rankx with filter

[procyon82]

I am pulling event data from Google Analytics and currently have a column that has all kinds of different files (pdf, docx, xlsx) and an other column with the associated number of downloads. So, for example, I know how many times a certain file was downloaded.

How can I rank file types within their own file types? In other words, how can I show the top 10 pdf files, top 10 docx files, etc. without using filters at the query level?

I've only managed to show the overall rank.

[PowerBIGuy · Accepted solution]

You can try implementing the following. 

Example:
Total Downloads= SUM(table[Downloads Fact])
Downloads Rank by FileType = RANKX(ALLSELECTED(table[FileType]), [Total Downloads])
Total Downloads Top 10 by FileType = IF([Downloads Rank by FileType] <= 10, [Total Downloads])