Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
Hi @ftorres
To compare different measures and get the max values, you could take SPG's suggestion
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
Hi @ftorres
To compare different measures and get the max values, you could take SPG's suggestion
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
MAX(MAX doesn't work: only accept a column-reference as an argument
Measure = MAX([TOTAL BAC], [TOTAL SPI])
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
94 | |
77 | |
65 | |
53 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |