cancel
Showing results for
Did you mean:
Helper II

## 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.

1 ACCEPTED SOLUTION
Super User

@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] )
)``````

Did I answer your question? Mark my post as a solution! and hit thumbs up
2 REPLIES 2
Helper II

Hi, now I got this:

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

Super User

@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] )
)``````

Did I answer your question? Mark my post as a solution! and hit thumbs up

Announcements

#### Power BI T-Shirt Design Challenge 2023

Vote for your favorite t-shirt design now through March 28.

#### Power BI March 2023 Update

Find out more about the March 2023 update.

#### March 2023 Events

Find out more about the online and in person events happening in March!

Top Solution Authors
Top Kudoed Authors