Filter Top N segmendted by another values

[Juramirez]

Hi all. I have a table with following data:

City	Worker ID	Orders
MX	1	10
COL	2	1
MX	3	2
US	4	3
MX	5	45
MX	23	5
MX	44	4
US	9	1
COL	8	2
COL	43	3
MX	22	55
MX	111	12
US	78	34
COL	49	47
US	98	90
MX	69	0

I want to show in a matrix visual the top 3 of Workers ID by Orders segmented by City (Top 3 MX, Top 3 US, Top 3 COL, etc...). The problem is that when I do the TOPN it shows the top 3 overall, not segmented by city.

Regards,

Julián

[v-cherch-msft]

Hi @Juramirez 

You may create a rank measure like below and use it in visual level filter.

Rank =
RANKX (
    FILTER ( ALL ( 'Table' ), 'Table'[City] = MAX ( 'Table'[City] ) ),
    CALCULATE ( SUM ( 'Table'[Orders] ) ),
    ,
    DESC
)

Regards,

[Juramirez]

Hi @v-cherch-msft 

Thanks for your answer but that's not the result i'm looking for:

This is my measure:

Regards,

Julián

[v-cherch-msft]

Hi @Juramirez 

Could you share the .pbix for us to check or provide more sample data which could reproduce your scenario?You can upload the .pbix file to OneDrive and post the link here. Do mask sensitive data before uploading.

Regards,