Forum Discussion
Power BI Matrix visual doesn't filter top 2 when column added
Hello everybody,
This is my data
I need to show top 2 manager with most tickets on matrix visual with ticketstate information. First I created count ticketID measure.
Count Ticket ID = COUNT(Tickets[TicketID])
Than I created rank measure
Rank Manager = RANKX(ALL(Tickets[Manager]), [Count Ticket ID], , DESC)
Then I applied on the filters rank Manager and got this view. Ranking works correctly. I see only 2 rows as I expected.
Then I applied on the filters rank Manager and got this view. Ranking works correctly. I see only 2 rows as I expected.
But to this table I need to add TicketState column too. When I add ticket state column I see 4 rows instead 2
I how no idea how to solve this issue. Can anybody help?
Thank you very much in advance.
1 Reply
lucadelicioImpactful Individual
Try to put the rank manager on the matrix and see what it shows.
I think you will have a top n default function on the count measure.
It's easier to help you if you upload your pbix file.
Mark as a solution if i help you.
Ciao