Forum Discussion
Top 25 user document count in Numerator
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.
nprasanthk , Try TOPN measure
calculate([Your Meausre], TOPN(25, allselected('Table'[User]), [Your Meausre],desc), values('Table'[User]))
2 Replies
- amitchandakSuper User
nprasanthk , Try TOPN measure
calculate([Your Meausre], TOPN(25, allselected('Table'[User]), [Your Meausre],desc), values('Table'[User]))
- nprasanthkFrequent Visitor
Hi Amit,
pefectly working, thank you.