cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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
New Ranks and Rank Icons in 2020

New Ranks and Rank Icons in 2020

Read the announcement for more information!

New Kudos Given Badges Coming

New Kudos Given Badges Coming

We're rolling out new Kudos Given badges. Find out how many Kudos you've given.

November 2019 Community Highlights

November 2019 Community Highlights

Get an overview of the events and great community content from November.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)