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

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

Need Help
Show and Tell

3 Replies

  • 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,