How to create a measure column to show the max value of two values and total by group

[topazz11]

Hello All

My goal is to have a maximum amount column that pick up higher value

[v-cherch-msft]

Hi @topazz11 

You may have a look at below articles to modify your measure.I would suggest you could turn off some totals under 'Format'->'Subtotals' if needed.

https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907

https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376

Regards,