The maximum of a sum

[ldroguett]

Hello guys, i have this problem.

I want to extract the greatest value from a sum, but when I get it out with a MAX, it doesn't work because it grabs other values.

for example, "Caja" is the sum of many processes, and the major process is "184" and that is the value that MAX takes.

Etiqueta	Cajas	Max Cajas
Eti1	9719	184
Eti2	6599	184
	2693	184

Result.

Etiqueta	Cajas
Eti1	9719

[ldroguett]

Any help??

[RobbeVL]

hi There,

I'm pretty sure MAXX will help you with your problem.
https://docs.microsoft.com/en-us/dax/maxx-function-dax 

I'm happy to help you further and write your measure if you share some sample data and an exact expected result.

Robbe

[ldroguett]

@RobbeVL  this is my measure:

Maximo Cajas = MAXX( Values(Table1[Table2.Etiqueta] ) ; Calculate(Sum(Table1[Cajas] ) ) )

It works but at 50%, it gives me the maximum value but not the name of the other columns, in this case, "Eti1".

[PattemManohar]

@Idroguett So what you are expecting is 9719 as Max of Cajas (assuming Cajas is sum of many processes)

[ldroguett]

Exactly @PattemManohar