Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon'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.
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.
Than I created rank measure
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.
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
User | Count |
---|---|
117 | |
73 | |
58 | |
49 | |
48 |
User | Count |
---|---|
171 | |
122 | |
60 | |
59 | |
56 |