Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Get top one category using DAX

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 C...
Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    5 years ago

    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

Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
5 years ago

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's avatar
Anonymous
Not applicable
5 years ago

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.