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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
0xygen27
Advocate II
Advocate II

Calculate top 25 users

Dear community, 

 

I want to calculate the percentage of the top 25 users of a tool I use. 

This way I can show that a small group of users is using the tool.

 

Columns I got are:

Ranking(most visits) |  amount of visits | % of total of total visits |

 

I thought about the column, but it isn't working. Can someone help me?

Column  = CALCULATE(TOPN(25,'table',[% of total visits],ASC)

Or I thought about filtering and use a filter 

 column = Filter('table)', 'column,DETAILROWS(25))

% of total visits = the amount of visits user / total visits 

1 REPLY 1
Anonymous
Not applicable

Looking for something similar - % of top 25 against total users.

 

Did you figure out how to do this?

Helpful resources

Announcements
Sept PBI Carousel

Power BI Monthly Update - September 2024

Check out the September 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

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