Minimum of the sum of two measures

[Anonymous]

Hi, 

I want to calculate the minimum of the sum of two measures using dax. 

For example:

Measure C = Measure A + Measure B

Measure A = sum(Table1, [FieldA])

Measure B = sum(Table1, [FieldB])

I've tried the MINX(Measure C) but it returns the minimum between A and B, i.e. MIN(A,B). I want the minimum of the measure C, on a aggregate basis.

If (A1 = 2 ; B1 =6), then C = 8 and (A2 = -1 ; B2 = 5) then C = 4, the MINX(Measure C) will return C1 = 2 andf C2 = -1, but I want the answer to be min(8,4) = 4

Thanks

[Greg_Deckler · Accepted solution]

See my article here:

https://community.powerbi.com/t5/Community-Blog/Design-Pattern-Groups-and-Super-Groups/ba-p/138149