Rankx count occurrance

[jfern78]

Hello community, I need to create a measure for a card that shows me the number of the 'Aging' column that is repeated the most, filtering another column called 'Active/Inactive' = "Inactive Portfolio"

I tried this.

RankCard =
var CountInactivePortfolio=  CALCULATE(COUNTA('Cartera Total'[system_no]),FILTER('Cartera Total','Cartera Total'[Active/Inactive']="Inactive Portfolio"))

return RANKX(ALLSELECTED('Cartera Total'[AGING Meses]),CountInactivePortfolio,CountInactivePortfolio,DESC,Dense)

But in the card it only shows me values 1 and 18.
And not the value that is repeated the most in the ranking.

[v-zhangti · Accepted solution]

Hi, @jfern78 

You can try the following methods.

Measure =
CALCULATE ( MAX ( 'Table'[AGING Meses] ),
    FILTER ( ALL ( 'Table' ),
        [Count] = CALCULATE ( MAX ( 'Table'[Count] ), ALL ( 'Table' ) )
    )
)

Please refer to the attachment.

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[jfern78]

any suggest?

[jfern78]

It doesn't work for me, what could be wrong?

Measure: 

Rankx = var prueba =

CALCULATE ( MAX ( 'Cartera Total'[SORT MES] ),

    FILTER ( ALL ( 'Cartera Total' ), CALCULATE(COUNTA('Cartera Total'[system_no]), 'Cartera Total'[SegmentacionMapa]="Cartera Activa C/ Mora")))

Return prueba

It returns the value 12 and it should return the value 2.

I use a calculate/counta.