Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
nprasanthk
Frequent Visitor

Top 25 user document count in Numerator

Hi All,

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

ex:

nprasanthk_0-1668534302574.png

 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.

nprasanthk_1-1668534632197.png

 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.

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@nprasanthk , Try TOPN measure

 

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

 

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

View solution in original post

2 REPLIES 2
amitchandak
Super User
Super User

@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.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors