Compare A to SUM of B and C

[ImG00dAtPowerBI]

Hi PowerBI Community!

Pretty new to this thing but I'm trying to wrap my head around the formulas.

I need to make a comparison of A to the SUM of B and C to find the missing amount between them but I don't know where to start.

Cheers

[v-xiaotang · Accepted solution]

Hi @ImG00dAtPowerBI 

Thanks for reaching out to us.

you can try this measure,

Measure = 
var _A= MAXX(FILTER('Table','Table'[Column1]="A"),[Column2])
var _B= MAXX(FILTER('Table','Table'[Column1]="B"),[Column2])
var _C= MAXX(FILTER('Table','Table'[Column1]="C"),[Column2])
return
_A-(_B+_C)

in this measure, _A, _B and _C get the value of A, B, C.

Best Regards,

Community Support Team _Tang

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

[tamerj1]

HI @ImG00dAtPowerBI 
What are A, B and C? Are they columns in the same table or measures? How does your report look like?