Skip to main content
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

Regular Visitor

Isolation of rank column from page level filter



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.




I have however a page level filter that shows  


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.



Daniel He

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

Helpful resources

Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.