RankX ordered by Text in Category

[Anonymous]

Hi,
Is it possible to make RankX column ordered by Name in Category
like in the picture

My try is not working...

Name_Rank =
RANKX(
FILTER('Table','Table'[name]=EARLIER('Table'[name])),
CALCULATE(
max(
'Table'[name]
),
ALLEXCEPT(Table,Table[category],Table[name])
),,DESC,Dense
)

What I need to insert in Calculate ??

[themistoklis]

Hello @Anonymous ,

Please try the following formula:

Rank = 
RANKX (
    FILTER ('Table', 'Table'[Category] = EARLIER('Table'[Category]) ), -- Grouping Column
    'Table'[Name],                                                     -- Sorting Column
    , ASC
)

[Anonymous]

Hi,
This good solution, but I have other columns in the table (this table only an example)
So I think needs to be any "all" function in the "calculate" function, but in calculate is possible using only aggregation...

[themistoklis · Accepted solution]

@Anonymous 

You can try the following measure:

If you want to add more filters make sure you declare the variable on top and then insert it in the ALLSELECTED area.

The following returns the same results

Sorting Rank = 
VAR _category = MAX ('Table'[Category] )
--VAR _secondvariable = MAX ( Sheet1[p_type] )
Return
    RANKX (
        FILTER (
            ALLSELECTED ( 'Table' ),
            'Table'[Category] = _category
  --              && Sheet1[p_type] = current_type
        ),
        CALCULATE ( MAX ( 'Table'[name] ) ),
        ,
        ASC,
        DENSE
    )