Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
39 | |
20 | |
19 | |
16 | |
15 |
User | Count |
---|---|
49 | |
26 | |
22 | |
17 | |
16 |