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
ftorres
Helper I
Helper I

MAXX of different measures or sum of different columns

Hi Guys 

How could I get the Max value of a row with different measures

 

TOTAL BAC = SUM('PM Month End KPI Data'[No. of BAC Entered])

TOTAL SPI = SUM('PM Month End KPI Data'[No. of SPI Entered]) 


Like this measure below
MAX = MAXX('PM Month End KPI Data',[TOTAL BAC] AND TOTAL SPI)

 

But I need max between those two measures

2 ACCEPTED SOLUTIONS
Anonymous
Not applicable

Measure = MAX([TOTAL BAC], [TOTAL SPI])

View solution in original post

v-juanli-msft
Community Support
Community Support

Hi @ftorres

To compare different measures and get the max values, you could take SPG's suggestion

4.png

max = MAX([Measure1],[Measure2])

But the "MAX" function only support one or two columns or measures to compare, if you need to compare more, you need to create other "MAX" measures or nest "max" function in "max" measure , for example,

Measure4 = MAX([max],[Measure3])

Or Measure = MAX(MAX([Measure1],[Measure2]),[Measure3])

 

 

Regarding MAXX function, it evaluates an expression for each row of a table and returns the largest numeric value. However, it seems not fit for this scenario, please see this link to know how to use it.

 

Best Regards

Maggie

 

 

 

View solution in original post

3 REPLIES 3
v-juanli-msft
Community Support
Community Support

Hi @ftorres

To compare different measures and get the max values, you could take SPG's suggestion

4.png

max = MAX([Measure1],[Measure2])

But the "MAX" function only support one or two columns or measures to compare, if you need to compare more, you need to create other "MAX" measures or nest "max" function in "max" measure , for example,

Measure4 = MAX([max],[Measure3])

Or Measure = MAX(MAX([Measure1],[Measure2]),[Measure3])

 

 

Regarding MAXX function, it evaluates an expression for each row of a table and returns the largest numeric value. However, it seems not fit for this scenario, please see this link to know how to use it.

 

Best Regards

Maggie

 

 

 

Anonymous
Not applicable

MAX(MAX doesn't work: only accept a column-reference as an argument

Anonymous
Not applicable

Measure = MAX([TOTAL BAC], [TOTAL SPI])

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.