DAX Min or Max with different Totals

[JohanData]

Hee Guys,

Could you please help me out calculating the right value?

[v-xicai]

Hi @JohanData ,

You can create measures like DAX below.

Markup 2=
var d= IF(MAX([Price])-MAX([Budget])<MAX([Price])-MAX([Spent]),MAX([Price])-MAX([Budget]), MAX([Price])-MAX([Spent]))
var _table = SUMMARIZE(Table1, Table1[ProjectNumber],"_Value", d)
return
IF(HASONEVALUE(Table1[ProjectNumber]), d, SUMX(_table,[_Value]))
 

Provision A=
var d= IF(MAX([Spent])-MAX([Price])>0,MAX([Spent])-MAX([Price]), 0)
var _table = SUMMARIZE(Table1, Table1[ProjectNumber],"_Value", d)
return
IF(HASONEVALUE(Table1[ProjectNumber]), d, SUMX(_table,[_Value]))

Best Regards,

Amy

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[parry2k]

@JohanData how you get to 20 for Min.

[JohanData]

70 + 10 +- 10 +- 10 +- 10 +- 30 = 20

[parry2k]

@JohanData share the pbix file with sample data and I can get you the solution.

[JohanData · Accepted solution]

@parry2k thanks for your support. I attached your solution. 

https://1drv.ms/u/s!AvDjQoL_zmjliHeFvA0HQ3n0VZgf?e=lKB4mw

Code:

Min = SUMX ( VALUES ( 'Dimension'[ProjectNr] ), MIN ( [Price - Budget], [Price - Spent] ) )

Max = SUMX ( VALUES ( 'Dimension'[ProjectNr] ), MAX ( [Spent - Price], 0 ) )