Rank by category and entity

[tsynenkyy]

Hi everyone,

I have this table:

I would like to see something like

DE013 - - - - 1

DE013 - - - - 2

DE013 - - - - 3

DE013 - - - - 4

DE018 - - - - 1

DE018 - - - - 2

DE018 - - - - 3

...

but my rank doesnt work:

Company_code and Category are in two diferent tables.

[tsynenkyy]

Hi, now I got this:

but the ranking is doing strange things, you can see a 2-3-2, how can I solve that?

[Fowmy · Accepted solution]

@tsynenkyy 

This measure shoudl work for you:

Rank Entity = 
VAR __CO = SELECTEDVALUE(Table1[Company_code])
RETURN
IF(
    [Spend],
    RANKX( FILTER( SUMMARIZE(all(Table1),Table1[Company_code],Table2[Category]) , Table1[Company_code] =__CO) ,[Spend] ) 
)