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

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

Reply
PPalkowski
Helper II
Helper II

Rank by filter

I am struggling with filter ranking

 

I have this rank working as expected

 

 

RankChanges = RANKX (
ALL ( 'Docuentation Issues'[Manager]),
CALCULATE ( COUNTA( 'Docuentation Issues'[Number] ) ))
 
I have another field I want to add to my visual named SumFail, still works... when I filter sumfail = 0, now my rankings are off and retain the value prior to the filter so I cannot show the top N. 
Any help? 
1 ACCEPTED SOLUTION
PPalkowski
Helper II
Helper II

 
I figured it out....
 
 
 
Rank Top = RANKX (
FILTER ( ALL( 'Docuentation Issues'[Manager]), 'Docuentation Issues'[SumFail] = 0),
CALCULATE ( COUNTA( 'Docuentation Issues'[Number] ) ))

View solution in original post

1 REPLY 1
PPalkowski
Helper II
Helper II

 
I figured it out....
 
 
 
Rank Top = RANKX (
FILTER ( ALL( 'Docuentation Issues'[Manager]), 'Docuentation Issues'[SumFail] = 0),
CALCULATE ( COUNTA( 'Docuentation Issues'[Number] ) ))

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

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