Forum Discussion
nprasanthk
3 years agoFrequent Visitor
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 % correc...
- 3 years ago
nprasanthk , Try TOPN measure
calculate([Your Meausre], TOPN(25, allselected('Table'[User]), [Your Meausre],desc), values('Table'[User]))
amitchandak
Super User
3 years agonprasanthk , Try TOPN measure
calculate([Your Meausre], TOPN(25, allselected('Table'[User]), [Your Meausre],desc), values('Table'[User]))
- nprasanthk3 years agoFrequent Visitor
Hi Amit,
pefectly working, thank you.