Calculating with measure in calculated column

Atticus_1

New Member
Joined
May 30, 2019
Messages
1
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:
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.

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.
 

Some videos you may like

Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.

Watch MrExcel Video

Forum statistics

Threads
1,102,305
Messages
5,486,072
Members
407,532
Latest member
shahbazfcca

This Week's Hot Topics

Top