Get top one category using DAX

[Anonymous]

I want to get the top category in this column using dax measure. That is, the category which is most repeated. Here it is AAA.

Category

AAA

AAA

BBB

BBB

AAA

BBB

AAA

CCC

How can I do that?

[Jihwan_Kim · Accepted solution]

Hi, @Anonymous 

Please check the below picture and the sample pbix file's link down below, for creating measures.

Repeated Count =

COUNTROWS('Table')

Most Repeated Category =

MAXX (

TOPN ( 1, ALL ( 'Table'[Category] ), [Repeated Count], DESC ),

'Table'[Category]

)

https://www.dropbox.com/s/ip97l4ibbjaa0zk/mah65v2.pbix?dl=0 

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM

[Anonymous]

How to show all if there are multiple categories with highest count?

For example, if AAA and BBB are both repeated 4 times (highest count), how to show them all as a concatenated text:    "AAA, BBB" ? 

Thanks.