Forum Discussion

Juramirez's avatar
Juramirez
Icon for Resolver I rankResolver I
7 years ago

Filter Top N segmendted by another values

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 ...
Need Help
Show and Tell
v-cherch-msft's avatar
v-cherch-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

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's avatar
Juramirez
Icon for Resolver I rankResolver I
7 years ago

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's avatar
    v-cherch-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    7 years ago

    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,