I currently have the below Measure. This works perfectly for all except for Location Code of 'SP'.
Does anyone know how I would adjust the measure so that if Location Code = SP then value = 450000. The intention is to use this in a Matrix visualisation, so Total would need to include this static value.
Currently Projected Sales =
'Current Month Sales',
"Projected Sales", ((([TOTAL W/O] * 200) + [Total Sales]) / [Work Days So Far]) * [Work Days]