RANKX on a column when I have legend for column chart

[ashaikh]

Hello,

I am creating a column chart. The column chart includes Location on Axis, Count of Ticket Number on Value, and Priority on Legend.  It looks like this - 

Here I want to view just Top 10 location based on Ticket Number. I can use below formula for that.

RANK LOCATION TICKET = IF(NOT(ISBLANK(tblNORTHWELL[TICKET COUNT])), RANKX(FILTER(ALL(tblNORTHWELL[Location]), tblNORTHWELL[TICKET COUNT]), tblNORTHWELL[TICKET COUNT], , ,Skip), BLANK())

This formula works perfectly when I don't Priority in Legends but when I include Priority it shows me all the records.

Can you please suggest a solution to include that.

Thanks

Abdul

[Vvelarde · Accepted solution]

@ashaikh

Hi, Could try using TopN in Visual Filter.

TOPN in Visual Level Filter