Forum Discussion
Solved
Switch and add a result
Dear all, I've this formula: Actual YTD + Forecast = var _YTD = CALCULATE([Amount], BIFRF000[Report] = "", BIFRF000[Period Type] = "T", BIFRF000[Type] = "V") var _Forecast = CALCULATE([...
LuisCaston82
Please try this measure:Actual YTD + Forecast = VAR _YTD = CALCULATE ( [Amount], BIFRF000[Report] = "", BIFRF000[Period Type] = "T", BIFRF000[Type] = "V" ) VAR _Forecast = CALCULATE ( [Amount], BIFRF000[Report Type] = "T" ) RETURN IF ( _YTD = 0, _Forecast, _YTD )
