cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
SWAST_IM New Member
New Member

Calculate percentiles of a set of means?

We have a dataset of managers with employees under each manager. 

 

For each employee we need to calculate their mean performance for a particular measure.

 

Then we need to rank each manager's employees to find a 25th percentile and mean performance value of this measure for each manager.

 

How would we do this in DAX for power bi report server?

 

Many thanks in advance for any tips.

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!