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.
To get percentage, I'm using a measure
Percentage=sum(NumUsers)/calculate(sum(NumUsers),Allselected(Event))
I know, power bi has a formula for percentiles but I cannot use it on a measure and having percentage as a calculated column is not giving the desired results. Thank you for your assistance.
Event | NumUsers | Percentage | 25th Percentile | 50th Percentile | 75th Percentile |
Write | 50 | 50% | |||
Add Color | 25 | 25% | |||
Add Picture | 15 | 15% | |||
Add document | 10 | 10% | |||
Total | 100 |
if I understand correctly you want to create 3 measures:
25th Percentile | 50th Percentile |
75th Percentile |
correct?
what would be the values for these measures? TRUE/FALSE, % value, something else?
That is right. I want the values to be percentiles not true/false
can you share how the expected output would look like?
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 |
---|---|
47 | |
22 | |
20 | |
15 | |
13 |
User | Count |
---|---|
49 | |
41 | |
39 | |
19 | |
19 |