Calculate Percentage and Percentile

[data_insights]

I want to calculate percentage of users by each event and then find out what percent of users are in each of the percentile buckets. Is that possible? 

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

[Anonymous]

To calculate percentiles one has to have a distribution of real values. That is, you have to have data points that can be ordered. What are your data points? 'Cause I can't see them...

Best
D

[Stachu]

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?

[data_insights]

That is right. I want the values to be percentiles not true/false

[Stachu]

can you share how the expected output would look like?