Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
User | Count |
---|---|
92 | |
85 | |
77 | |
66 | |
62 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
59 |