Forum Discussion
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 |
| CCC |
How can I do that?
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
2 Replies
- Jihwan_Kim
Super User
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