Forum Discussion

sgsukumaran's avatar
sgsukumaran
Icon for Resolver II rankResolver 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'[LYRollingF...
Need Help
v-jiascu-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft 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