How to substract measures as a new measure

[Anonymous]

Hello great analytics minds:

I am enjoying learning Power BI from you guys. Appreciate your help. 

I have a question, How can I substruct measures and creat a new measure.

Measure diff = CALCULATE(SUM('Table_query__1'[Measure dl Complete Count])+[Measure dl In progress On Track]-CALCULATE(SUM([Measure dl In progress Past Due])))

Appreciate your help.

Thanks

[Anonymous]

Unfortunetly VAR _A , B, C is not coming up in my formula window.

[Arul]

@Anonymous ,

Can you share the error messages?

Thanks,

Arul

[Arul]

@Anonymous ,

Do you want to calculate the above in a single measure?

Thanks,

Arul

[Arul]

@Anonymous ,

Do you want to calculate the above in a single measure?

Thanks,

Arul

[Anonymous]

yes

[Arul]

@Anonymous ,

can you try this,

Measure diff = 
VAR _A = SUM('Table_query__1'[Measure dl Complete Count])
VAR _B = [Measure dl In progress On Track]
VAR _C = SUM([Measure dl In progress Past Due])
return _A+_B-_C

Thanks,

Arul

[Anonymous]

I am not getting the result. 😞

[Arul]

@Anonymous ,

share the error that you are getting.