What's wrong with this formula??

[Badrul]

IF ([CurrentLevel] = 1, CALCULATE(SUM([Amount])/1000000, tblAccountRollupNew[SignAtLvl1] = 1,tblAccountRollupNew),0)

The problem is that tblAccountRollupNew[SignAtLvl1] = 1 does not seem to affect the formula at all. I could write tblAccountRollupNew[SignAtLvl1] = 9999 and stil get the same result. I have numbers coming through so I know it is calculating. I could remove the second filter too and it will behave like there are not filters at all.

What's going on?

 

[Badrul]

I've narrowed the problem down to the fact that tblAccountRollupNew is not directly linked to the table that contains amounts. Instead it is a sub table of another table is in turn directly linked to the amounts table.

But I thought PP is able to handle this?

 

[miguel.escobar]

try this
IF ([CurrentLevel] = 1, CALCULATE(SUM([Amount])/1000000, FILTER(blAccountRollupNew, blAccountRollupNew[SignAtLvl1] = 1 && tblAccountRollupNew) ),0)