I have prepared a measure that returns a certain rate determined to be calculated only within a certain part. But then when I call this measure, only blank is returned, even though the measure shows a number.
I have prepared a condensed example Power Pivot model that explains what needs to be calculated in the sheet "Problem":
https://tinyurl.com/y3j6kac3
So the measure (that is correct) is called [DB je Nutzer HKA] and the following is what should be calculated, either as a measure or calculated column:
Any idea why this does not work? Please try it out in my little sample model, which is condensed from a quite complex model. I am using Power Pivot in Excel 2013.
I have prepared a condensed example Power Pivot model that explains what needs to be calculated in the sheet "Problem":
https://tinyurl.com/y3j6kac3
So the measure (that is correct) is called [DB je Nutzer HKA] and the following is what should be calculated, either as a measure or calculated column:
SUMX(Ziele;
[Istwert] *
switch(True();
[Zielbereich]="Kündigungen" && [Typ]="HKA (u.a.)";
[DB je Nutzer HKA u.a.]
;
0
)
)
It means the ratio should be multiplied with the column "Istwert", so that a total cost is derived for the filtered section.[Istwert] *
switch(True();
[Zielbereich]="Kündigungen" && [Typ]="HKA (u.a.)";
[DB je Nutzer HKA u.a.]
;
0
)
)
Any idea why this does not work? Please try it out in my little sample model, which is condensed from a quite complex model. I am using Power Pivot in Excel 2013.
