Limiting Top N to only the top 5 records where a count is being filtered

[TomBINGL]

Hi all,

I have a large dataset which is primarily focusedon service provision data (support ticket logging). I've seen a fair few different posts around ranking based on a rankx funcitonetc. but I can't quite get what I need out of the information available. I tihnk this is down to the fact I'm using a measure rather than a column to achieve what I need here.

I'm fairly new to any in-depth DAX functions so apologies for if this is a fairly obvious one.

I have tried a couple of recommended solutions from previous posts but I can't quite get it to work, I'm looking to get a dynamic function in place rather than manually filter out duplicate counts (by contact).

I'm attempting to distinctly count a ticket ID (using a measure) to see number of tickets logged per user (contact) and visualise those by the corresponding user in descending order in a bar chart (effectivley creating a rank). The ticket ID count measure is being used to filter on Top N (top 5 results) but where duplicates of the ticket ID count exist I'm seeing more than the top 5.

So in relation to the below image (Resulting table), where we see duplicate counts (Andy has logged 2 support tickets and so have Chloe, Emily, Kyle Lauren and Stephen) we only want to see the top 5 displayed, with any duplicates limited to equate to the top 5 only.

The data being pulled into the visual is set up in two tables, one with ticket records and the other with contacts using an ID as the key.

Contacts table:

Tickets table:

Resulting table example (Rank added for example purposes only):

Filters on visual in PBI desktop:

 Bar chart in PBI desktop:

Any help would be greatly appreciated.

Many thanks,

Tom