Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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
Looking for something similar - % of top 25 against total users.
Did you figure out how to do this?
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
25 | |
19 | |
18 | |
18 | |
15 |
User | Count |
---|---|
39 | |
22 | |
18 | |
15 | |
12 |