"Other" category in the last row of a table visual (RANKX and OTHER)"

[MorenoRichard]

I use the command below to create a table to select the top five quantities, putting the rest into the "Others" category. I would like the "Others" row to be at the bottom of a table visual.

TopMedicosPorEstados =

VAR _top = 5

VAR _TotalOutros =

    IF (

        SELECTEDVALUE ( '~TEMP_UF_MEDICOS'[UF] ) = "Outros",

        CALCULATE (

            [nMedicosRegulares],

            FILTER ( ALL ( '~TEMP_UF_MEDICOS'[UF] ), [nRankMedicos] > _top )

        )

    )

VAR _TotalTop =

    IF ( [nRankMedicos] <= _top, [nMedicosRegulares], _TotalOutros )

RETURN

    _TotalTop

Where 

nRankMedicos =

RANKX ( ALL ( '~TEMP_UF_MEDICOS'[UF] ), [nMedicosRegulares],, DESC )

and

nMedicosRegulares =

CALCULATE (

    DISTINCTCOUNT ( DIM_MEDICOS[CPF] ),

    DIM_MEDICOS[DESCRICAO_SIT] = "Regular"

See the table: (outros = others)

Any idea? Thanks!

[MorenoRichard]

You're genius. Thanks!

[ThxAlot · Accepted solution]