Forum Discussion
Rank by category and entity
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.
Anonymous
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] ) )
2 Replies
- Fowmy
Super User
Anonymous
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] ) )