Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |