Forum Discussion

sgsukumaran's avatar
sgsukumaran
Resolver II
8 years ago

If statement for Calculate

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

 

 

Need Help

1 Reply

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    8 years ago

    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