Top 25 user document count in Numerator

[nprasanthk]

Hi All,

I am trying to find the top 25 users document count in Numerator.

ex:

 109969 count is Top 25 Users document count and 195098 is total user document count. 109969/195098= 56 % correct

Now problem is when select Month then need the Top 25 users document in Numerator.

 Selected the Oct21 month then top 25 user count is 10039 and total count for that month 12429.

10039/12429 is required.

like that for all months need.

Please help on this query. 

Thanks in Advance.

[amitchandak · Accepted solution]

@nprasanthk , Try TOPN measure

calculate([Your Meausre], TOPN(25, allselected('Table'[User]), [Your Meausre],desc), values('Table'[User]))

TOPN: https://youtu.be/QIVEFp-QiOk

[nprasanthk]

Hi Amit,

pefectly working, thank you.