Dax Calculation

[Guinaba]

Hi guys,

I am using DAX to calculate : (A-B)/B, so using DAX I did the following:

Total_Fcst = sum(Fcst (LItrres))
Total_PO = sum(PO (LItres)
Fcst/PO (%) = (Total_Fcst - Total_PO)/Total_Fcst , but I am not gettng the same result as the validation. Should I fix the denominator?

 

[sadath]

in validation you are using (Total_Fcst - Total_PO)/Total_PO
instead of (Total_Fcst - Total_PO)/Total_Fcst