I am doing a comparison and everything works except when the current value is blank for the CY but not blank for the PY.
Any thoughts?
Mat Usage Sum =
sumx(VALUES(‘All data new’[Component Material]),
CALCULATE(sumx(VALUES(‘All data new’[Component Description]),[YOY Component Diff])))