Conditional calculation

[Anonymous]

Hi there,

I have a task where i have to calculate electrical tariff. However i cant get pass through getting the DAX codes right for the conditional calculation, i would appreciate some help.

What i want to achieve is:

1. If total consumption is below 200 kwh, the total consumption will be multiplied by 0.435

2. If the total consumption is more than 200 kwh,

    The first 200kwh will be multiplied by 0.435 and value over 200kwh will be multiplied by 0.509

[Anonymous]

Thank you so much, works well for me !

[bcdobbs · Accepted solution]

Assuming you have an existing measure for [Total Consumption] I think the following works:

Electrical Tariff = 
VAR TotalConsumption = [Total Consumption]

VAR Result =
	IF (
		TotalConsumption <= 200,
		TotalConsumption * 0.435,
		(200 * 0.435) + (TotalConsumption - 200)*0.509
		)
		
RETURN Result