cancel
Showing results for 
Search instead for 
Did you mean: 
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
SPG
Resolver IV
Resolver IV

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

 

 

 

View solution in original post

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

SPG
Resolver IV
Resolver IV

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

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!