Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
Solved! Go to 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 , Try TOPN measure
calculate([Your Meausre], TOPN(25, allselected('Table'[User]), [Your Meausre],desc), values('Table'[User]))
TOPN: https://youtu.be/QIVEFp-QiOk
Hi Amit,
pefectly working, thank you.
User | Count |
---|---|
41 | |
27 | |
23 | |
19 | |
16 |
User | Count |
---|---|
54 | |
35 | |
19 | |
19 | |
15 |