none
Calculating with measure in calculated column RRS feed

  • Question

  • 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.
    Friday, May 31, 2019 6:05 AM

All replies