DAX Measure to return the name of the largest category

[andre_kroker]

Hi All()

Considering I have the following column chart:

Where the category in the axis is Age Range, and the values on each column are actually a measure the counts the number of a certain group of people falling in those categories (it is actually a very simple measure).

I want a card that returns the category with the largest amount of people on it. Considering the chart above, the card would return "De 20 a 30". As simple as that.

Any thoughts?

[ValtteriN · Accepted solution]

Hi,

Try utilizing MAXX:
e.g.

Measure 18 = var _table = topn(1,SUMMARIZE('Table (7)','Table (7)'[Column1],"Sum",SUM('Table (7)'[Column2])),SUM('Table (7)'[Column2]))

return

maxX(_table,'Table (7)'[Column1])


You can replace sum with count. 


Example data:

End result:

I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/

[andre_kroker]

Dear @ValtteriN 

The solution you provided works well, Thank you SO MUCH for your prompt response 😃
I chose to author the measure a bit different, with an ADDCOLUMNS statement surrounding the measure. (Marco Russo and Alberto Ferrari say this is a best practice in some cases. Please refer to this video https://www.sqlbi.com/articles/best-practices-using-summarize-and-addcolumns/).

Thank you so much once again! Going accept this as a solution and connect with you on Linkedin.
Regards!