topic Re: Calculate Percentage and Percentile in DAX Commands and Tips

Calculate Percentage and Percentile

data_insights — Tue, 24 Mar 2020 22:12:02 GMT

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

Re: Calculate Percentage and Percentile

Stachu — Fri, 27 Mar 2020 10:47:30 GMT

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?

Re: Calculate Percentage and Percentile

data_insights — Mon, 30 Mar 2020 15:46:28 GMT

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

Re: Calculate Percentage and Percentile

Anonymous — Mon, 30 Mar 2020 16:21:25 GMT

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

Re: Calculate Percentage and Percentile

Stachu — Tue, 31 Mar 2020 07:06:04 GMT

can you share how the expected output would look like?