Filtering by RANKX

[Anonymous]

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

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

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?)

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).

Data model

[Anonymous]

Hi @Anonymous ,

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

Best Regards,

Jay

[Anonymous]

Hi, @Anonymous 

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]

You can try an expression like this one.

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

Pat

[Anonymous]

Sadly, same results @mahoneypat 

[amitchandak]

@Anonymous , 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

[Anonymous]

Sadly same results @amitchandak