If statement for Calculate

[sgsukumaran]

I am trying to get this If statement worked on muliple Calculate logic and it always turns blank. 

,IF( [Base]=2 ,(CALCULATE( [Sales] ,FILTER( ALL('Fiscal Calendar') ,'Fiscal Calendar'[LYRollingFiscalWeek]=1 ) ,KEEPFILTERS('Sales'[UnitID]=51) ))
,CALCULATE( [Sales] ,FILTER( ALL('Fiscal Calendar') ,'Fiscal Calendar'[LYRollingFiscalQuarter]=1 ) ,KEEPFILTERS('Sales'[UnitID]=51)) ) 

When I run this separately they run fine.

CALCULATE( [Sales] ,FILTER( ALL('Fiscal Calendar') ,'Fiscal Calendar'[LYRollingFiscalWeek]=1 ) ,KEEPFILTERS('Sales'[UnitID]=51) ) with base = 2

[v-jiascu-msft]

Hi @sgsukumaran,

Can you share the pbix file? A dummy one is enough. A measure evaluates under its context. The formula just looks fine. So there could be something wrong with other parts.

Best Regards,

Dale