Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
User | Count |
---|---|
54 | |
22 | |
19 | |
16 | |
11 |
User | Count |
---|---|
81 | |
55 | |
40 | |
19 | |
12 |