Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
TanayKuzey
New Member

Power BI Matrix visual doesn't filter top 2 when column added

 

Hello everybody,

This is my data

TanayKuzey_0-1688137347838.png

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.
TanayKuzey_2-1688137742064.png

But to this table I need to add TicketState column too. When I add ticket state column I see 4 rows instead 2

TanayKuzey_3-1688137824874.png


I how no idea how to solve this issue. Can anybody help?
Thank you very much in advance.

1 REPLY 1
lucadelicio
Super User
Super User

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



Luca D'Elicio

LinkedIn Profile

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.