topic Rankx count occurrance in DAX Commands and Tips

Rankx count occurrance

jfern78 — Thu, 10 Aug 2023 15:25:19 GMT

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.

Re: Rankx count occurrance

v-zhangti — Mon, 14 Aug 2023 06:57:41 GMT

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.

Re: Rankx count occurrance

jfern78 — Thu, 31 Aug 2023 19:28:34 GMT

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.

Re: Rankx count occurrance

jfern78 — Mon, 04 Sep 2023 13:46:17 GMT

any suggest?