Forum Discussion

PPalkowski's avatar
PPalkowski
Icon for Helper II rankHelper II
6 years ago
Solved

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] )...
  • PPalkowski's avatar
    PPalkowski
    6 years ago
     
    I figured it out....
     
     
     
    Rank Top = RANKX (
    FILTER ( ALL( 'Docuentation Issues'[Manager]), 'Docuentation Issues'[SumFail] = 0),
    CALCULATE ( COUNTA( 'Docuentation Issues'[Number] ) ))
PPalkowski's avatar
PPalkowski
Icon for Helper II rankHelper II
6 years ago
 
I figured it out....
 
 
 
Rank Top = RANKX (
FILTER ( ALL( 'Docuentation Issues'[Manager]), 'Docuentation Issues'[SumFail] = 0),
CALCULATE ( COUNTA( 'Docuentation Issues'[Number] ) ))