Isolation of rank column from page level filter

[Tomo2709]

Hi

My data set is ordered like this:

[FIRM]   [OverallRating]

Firm A    4

Firm A    3

Firm A    3

Firm B    5

Firm B    4

and so on

The OverallRating is an average of 5 other columns of data.

I have created a measure: avg = AVERAGE(Evaluations[OverallRating])

I used this in a rank expression: myRank = rankx(all('Evaluations'[Firm]),[AVG])

Prduced a table with firm and myRank listed and it works pefectly to show the ranked averages by firm.

I wanted however to do two things. 

1) Just show the ranking for the selected firm in a power BI card (for the firm that i am filtering on). 

2) Carrying on from point 1 above, dont show any ranking when i have all firms selected

What currently happens is that when i filter the worksheet (i have a page level filter in place) by "Firm A".  The card shows Firm A as ranking "1" (because it is the only firm in the filtered data set.  The table i created also shows Firm A as ranking number 1 and all other firms as ranking 2 when in reality Firm A ranks 5th.

Any idead how i isloate the card so that when i select a firm from the page level filter dropdown it shows their actual ranking? 

Sorry i really hope this makes sense.

P

I have however a page level filter that shows  

[v-danhe-msft]

Hi @Tomo2709,

Due to I could not figure out the sentence "Prduced a table with firm and myRank listed" and  your data stracture, could you please post me your data picture and your desired result? I suggest you to share the pbix file if possible.

Regards,

Daniel He