Forum Discussion
sraj
Responsive Resident
Responsive ResidentMeasure for subtraction
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])
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
2 Replies
v-henryk-mstfCommunity Support
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
srajGot it, finally it worked. Thank you for pointing that!!