cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Microsoft
Microsoft

Calculate Percentage and Percentile

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.

 

EventNumUsersPercentage25th Percentile50th Percentile75th Percentile
Write5050%   
Add Color2525%   
Add Picture1515%   
Add document1010%   
Total100    
4 REPLIES 4
Highlighted
Super User II
Super User II

Re: Calculate Percentage and Percentile

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?

Did I answer your question? Mark my post as a solution!
Thank you for the kudos 🙂

Proud to be a Datanaut!

Highlighted
Microsoft
Microsoft

Re: Calculate Percentage and Percentile

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

Highlighted
Anonymous
Not applicable

Re: Calculate Percentage and Percentile

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
Highlighted
Super User II
Super User II

Re: Calculate Percentage and Percentile

can you share how the expected output would look like?

Did I answer your question? Mark my post as a solution!
Thank you for the kudos 🙂

Proud to be a Datanaut!

Helpful resources

Announcements
Super Users of the Quarter - Q2 2020

Super Users of the Quarter - Q2 2020

Who are our Super User Superstars? Who made it to the top of the leaderboards? Get the answers!

June 2020 Community Highlights

June 2020 Community Highlights

Featured community members, changes to the Community, and more! Read up on recent Power BI community news.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Power Platform 2020 release wave 2 plan

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors