Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
ldroguett
Frequent Visitor

The maximum of a sum

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.

 

EtiquetaCajasMax Cajas
Eti19719184
Eti26599184
 2693184

 

Result.

EtiquetaCajas 
Eti19719 
   
   
5 REPLIES 5
ldroguett
Frequent Visitor

Any help??
RobbeVL
Impactful Individual
Impactful Individual

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

@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
Community Champion
Community Champion

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




Did I answer your question? Mark my post as a solution!

Proud to be a PBI Community Champion




Exactly @PattemManohar 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.