Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
MohamedHesham
Frequent Visitor

Filtering by RANKX

I am relatively new to DAX and I have been trying to use RANKX to filter the top 3 medalists as seen below.

MohamedHesham_2-1630943707222.png

 

This is the result, which is true (Neglecting the total)

MohamedHesham_4-1630944066490.png

 

But the moment I try to map the ID to name and gender (both are in another table, see below) it starts to acting in a unexpected way. For Example (is this top 3 for each gender?)

MohamedHesham_7-1630944445319.png

 

 

This is what I am trying to achieve (This was by using Top N in the Filter panel but I want to use DAX instead).

MohamedHesham_3-1630943830457.png

Data model

MohamedHesham_6-1630944352206.png

 

 

 

 

6 REPLIES 6
v-jayw-msft
Community Support
Community Support

Hi @MohamedHesham ,

 

Can you share some sample data so that we could check the formula?

 

Best Regards,

Jay

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution
to help the other members find it.

Hi, @v-jayw-msft 

This is just a personal project to gain hands on experience using Power BI, so feel free to view the whole file.

I created a report page called "TESTING TOP N" where you can check the formula and what I am trying to achieve.

 

Thank you in advance.

 

 

 

 

mahoneypat
Microsoft Employee
Microsoft Employee

You can try an expression like this one.

 

 

Top 3 Medal Count =
VAR top3 =
    TOPN ( 3ALLSELECTED ( 'Medalists'[ID] ), [Total Medals Medalists], DESC )
VAR result =
    CALCULATE ( [Total Medals Medalists], KEEPFILTERS ( top3 ) )
RETURN
    result

 

Pat

 





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


Sadly, same results @mahoneypat 

MohamedHesham_0-1630958261685.png

 

MohamedHesham_1-1630958274316.png

 

amitchandak
Super User
Super User

@MohamedHesham , Try TOPN

example

calculate([total medal medlist],TOPN(3,allselected(Table[ID]),[total medal medlist],DESC), values(Table[ID]))

 

TOPN: https://www.youtube.com/watch?v=QIVEFp-QiOk&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=42

Sadly same results @amitchandak 

MohamedHesham_0-1630946842406.png

 

MohamedHesham_1-1630946867023.png

 

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.