Forum Discussion

94veiga's avatar
94veiga
Helper II
5 years ago
Solved

Table with TOP N category

I have a table like this   IdEMP Profession Income EMP0001 Chef 200 EMP0001 Waiter 100 EMP0001 Sous-Chef 50 EMP0002 Sous-Chef 300 EMP0002 Waiter 100   I want to g...
Need Help
  • v-yingjl's avatar
    v-yingjl
    5 years ago

    Hi 94veiga ,

    You can create a measure like this, put it in the visual filter and set its value as 1:

    Rank = 
CALCULATE (
    RANKX (
        FILTER ( ALL ( 'Table' ), 'Table'[IdEMP] IN DISTINCT ( 'Table'[IdEMP] ) ),
        'Table'[Income],
        SUM ( 'Table'[Income] ),
        DESC,
        DENSE
    )
)

    Attached a sample file in the below, hopes it could help.

     

    Best Regards,
    Community Support Team _ Yingjie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-yingjl's avatar
v-yingjl
Community Support
5 years ago

Hi 94veiga ,

You can create a measure like this, put it in the visual filter and set its value as 1:

Rank = 
CALCULATE (
    RANKX (
        FILTER ( ALL ( 'Table' ), 'Table'[IdEMP] IN DISTINCT ( 'Table'[IdEMP] ) ),
        'Table'[Income],
        SUM ( 'Table'[Income] ),
        DESC,
        DENSE
    )
)

Attached a sample file in the below, hopes it could help.

 

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.