Forum Discussion
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] ) ))
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?
- I figured it out....Rank Top = RANKX (FILTER ( ALL( 'Docuentation Issues'[Manager]), 'Docuentation Issues'[SumFail] = 0),CALCULATE ( COUNTA( 'Docuentation Issues'[Number] ) ))
1 Reply
- I figured it out....Rank Top = RANKX (FILTER ( ALL( 'Docuentation Issues'[Manager]), 'Docuentation Issues'[SumFail] = 0),CALCULATE ( COUNTA( 'Docuentation Issues'[Number] ) ))