How to show display only the most common item in collum

[Anonymous]

Hello everyone my name is Taniguchi.

I have a table called incidents and is this table i have a collum named clients, i need to know which cliente is opening more incidents. How can i display only the most common item in the collum ?

[darentengmfs · Accepted solution]

@Anonymous 

Use the filter to get it. Filter it by your column with the Filter Type "Top N", show Top 1 items by the count of your column.

[ToddChitt]

Sounds like you want the Top 10 Customers by Incident Count.

Create a Table visual and drag in Client Name and some COUNT measure. In the Filters for Cleint, select Top N as the Filter Type, Top as the Show Items, a number next to it, like 10, and for By Value, the Count measure.

The Count measure can simply be COUNTROWS('incident')