Calculate of a new KPI doesn't work

[#1]

Hey,

there are two tables Price and Payoff. I want to calculate the new KPI PriceCalc like

if(ConsumptionFrom<=Consumption and Consumption<=ConsumptionTo, BasicRate+EnergyRate*Consumption,-999).

I get only the value -999 for all CustomerID and don't know why.

Best regards

[Gysbert_Wassenaar]

Try adding ConsumptionFrom and ConsumptionTo as dimensions. There are several values per customer.

[#3]

thanks for your answer. but adding ConsumptionFrom and ConsumptionTo as dimensions chances nothing.