Forum Discussion

Nas's avatar
Nas
New Member
5 years ago

Filter by Field

Hi, May I please ask if its possible to filter Top 5 by field. The field contains Dom Air, Reg Air , Int Air. I would like to filter top 5 routes by Trns used by Dom Air, Reg Air, Int Air in one visu...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Nas ,

It seems like the the  are in the same column and you want to calculate each category's Top5 value, right?

rankTop5 =
RANKX (
    FILTER ( ALL ( 'Table' ), 'Table'[Column1] = MAX ( 'Table'[Column1] ) ),
    CALCULATE ( MAX ( ( 'Table'[Value] ) ) ),
    ,
    DESC
)

Did I answer your question ? Please mark my reply as solution. Thank you very much.

If not, please upload some insensitive data samples and expected output.

 

Best Regards,

Eyelyn Qin