Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Average top x from measure with filter


i need help, i have rank via measure _conversion. I need for different teams and different weeks to display the average conversion for top 4 peoples.


PBIX file 


I am attaching a test file.

Please could someone help me?


Frequent Visitor

Thank you very much, that's exactly it. 😉

Super User
Super User


Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension!

DAX is simple, but NOT EASY!

Helpful resources

Join Arun Ulag at MPPC23

Join Arun Ulag at MPPC23

Get a sneak peek into this year's Power Platform Conference Keynote.

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Top Solution Authors