I have a hierarchy with 3 levels, third level is Konto ( 35100 ) and 2nd level is Engagement margin. I want to multiply my amount(Utfall) with a Sign (+/-) ONLY when we are on level 3. So this is how I created the measure:

UtfallSign:= IF(HASONEFILTER(Konto,[UtfallOld][Sign], [UtfallOld])*

I also tried with ISINSCOPE which gives the same result.

UtfallOld is base measure for Amount ( sum(amount) )
In this case the measure returns 0 after multiplying with Sign and if we stand on level 3 it shows 0, problem is that I don´t want to use the sign on level 2, only on level 3. But I DO want the sum to be correct on level 2, so in this case I want the sum on level 2 to be 0 even though I don´t use the sign measure on this level.

My actual question is this:

When looking in Power BI I get expected result, but when looking on same data in Pivot table in Excel I get another behavior. What is the difference here and how can I get the table in Excel to sum up to 0 when standing on level 2 just like it does in Power BI?

Thank you for your time!