Return the number of rows by select the largest value from a column

[ChaCha123]

Hi Guys,

I would like to have the return which the largest number of column g by group of a,b,c and date

Table Name: Fruit

My expected result

I using this DAX but this is not return on what the expected result

CM = 
SUMX(SUMMARIZE(Fruit,Fruit[date],Fruit[a],Fruit[b],Fruit[c],"CMs",1),[Cms])

Apperciate your reply.

[Anonymous]

Hi @ChaCha123 ,

I'm a little confused about your needs, Could you please explain them further?

Thanks for your efforts & time in advance.

Best regards,
Community Support Team_Binbin Yu

[rubayatyasmin]

Hi, @ChaCha123 

Simply use CM = MAX(Fruit[g])

this will return the large number for the row. Then visualize it in a table. 

And for second row in your expected result CM should be 2. rught? As, third row in your table has g col value 2. 

[ChaCha123]

Hi,

the second row is 1 , even the a, b, c, date and e is same but different f and g