Help need to show top Age group with highest Sales

[Thilini]

Hi All,

I am trying to write a dax formula to get the highest sales value and the age group into multi row card in my dashboard. Really appreciate If anyone can anyone assist me on this please.

The test case shown as below.

Thank you!

Thilini

[Anonymous]

When asking a question like this, it's important to show the model. Or at least the part of it that holds all the relevant data.

[amitchandak]

@Thilini , top 1

Top 1 Age Group = CALCULATE([Sales],TOPN(1,all(Table[Age Group]),[Sales],DESC),VALUES(Table[Age Group]))

[Thilini]

Hi @amitchandak ,

Thank you for your solution. It works fine.

But only address part of my question. I use it to get the sales value of the top 1 age group. 

Really appreciate your help.

Kind Regards,

Thilini

[Greg_Deckler · Accepted solution]

@Thilini Hard to say with that information, looks like a Lookup Min/Max issue:

https://community.powerbi.com/t5/Quick-Measures-Gallery/Lookup-Min-Max/m-p/985814#M434

For a more specific solution, please post sample source table data as text in a table. Thanks.

[Thilini]

Hi @Greg_Deckler,

I tried your solution. It works perfectly fine. I get both name of the top 1 age group as well as the top 1 sales value.

Thank you so much!

Kind Regards,

Thilini