Cannot use two filters dependent on each other

[Anonymous]

I have created a table with four columns Referee, RefereeCardRate, Number of Matches for referee and TotalCard. 

I want to apply two filters: 

• Referee with more than 50 matches
• And after applying the first filter, display top 10 referee.

The number of matches for top 10 referee according to the RefereeCardRate is 0. Hence when I apply the filter on number of matches > 50 and then select top 10 referee with referee card rate it displays zero.

What I want is when i filter number of matches >50, whatever I see on the visual I want to select top 10. 

I have tried different thinks like changing measures to columns, using measures as filter, slicing. But they all give the same result.

I have attached a photo about how my data looks, and the measure columns I am using. 

If anyone can help, that will be much appreciated.

[Ashish_Mathur]

Hi,

Share the link from where i can download your PBI file.  If possible, please show the result very clearly.

[Anonymous]

https://drive.google.com/file/d/1x1SBBZTmsHhOiKmrBI5uD9IphieJF4_U/view?usp=sharing

I have uploaded my pbix here.

[Ashish_Mathur · Accepted solution]

Hi,

Download my PBI file from here.

Hope this helps.

[Anonymous]

Thanks Ashish, good think to learn this measure. 

Rank = if([Number of Matches for referee]<50,BLANK(),RANKX(FILTER(ALL(Datasets[Referee]),[Number of Matches for referee]>50),[RefereeCardRate]))

[Ashish_Mathur]

You are welcome.