Measure for subtraction

[sraj]

Hello,

I am trying to substract between these 3 measures, is this the right way to do it?  Because the value I am getting is not what I expected.  

493403 - 4297 - 477048 = 12,058 is what I am expecting but with the below measure I get this value 942470.

Total Remaining =

max('sched/status mrkt'[pers_held_cnt]) + max('sched/status mrkt'[real_held_cnt]) -

MAX('sched/status mrkt'[pp_pro_cnt]) +  MAX('sched/status mrkt'[rp_pro_cnt]) +

MAX('sched/status mrkt'[pp_others_pro_cnt]) + MAX('sched/status mrkt'[rp_others_pro_cnt]) +  MAX('sched/status mrkt'[rp_prescheduled_pro_cnt]) -

MAX('sched/status mrkt'[pp_bad_pro_cnt]) + MAX('sched/status mrkt'[rp_bad_pro_cnt])

[v-henryk-mstf · Accepted solution]

Hi @sraj ,

Can you provide the specific formula corresponding to the 3 MEASURES and test data, I suspect that the external filtering context is causing the wrong values.

How to provide sample data in the Power BI Forum - Microsoft Power BI Community

Looking forward to your reply.

Best Regards,
Henry

[sraj]

Got it, finally it worked.  Thank you for pointing that!!