Discount of Total

[Anonymous]

Hi All,

I have a total number of calls (2399) that needs to be discounted as follows;

For first 1000 calls we don't give discount, meaning we charge 2 euro per call.

For calls between 1000 and 1500 we give discount of 20 cents, meaning we charge 1.80 euro per call.

For all calls greater than 1500 we give discount of 30 cents, meaning we charge 1.70 euro per call.

I don't know how to make this work? Not sure what logic/formula/function is the best to use in this case.

Number of Calls is defined as: NoOfCalls = COUNT(Query1[requestid])

I hope you can help me and give some tips.

Thanks,

[Whitewater100]

Hi:

Most liely a conditional statement 

first have measure to total up calls e.g. No of Calls = SUM(TableName[No Calls])

Then 

IF([NoofCalls] > 1500, [NoofCalls] * 1.7, IF([NoofCalls] >= 1000, [NoofCalls] * 1,8, [NoofCalls] * 2)))

[Anonymous]

Thanks a lot but I am getting the following error;

Do you know what I am missing there?

[Whitewater100]

IF([NoofCalls] >= 1500, [NoofCalls] * 1.7, IF([NoofCalls] >= 1000, [NoofCalls] * 1.8,  [NoofCalls] * 2))

It's evaluated in order that's why we can start with 1500, then the next one covers between 1000 -1499

and the last part is for all the calls under 1000. I hope this helps.

[Whitewater100]

Hi:

It should work.

Here is the syntax using easier numbers to follow. After each comma I skip one space. Two )) at the end. I just tested it.

You can substitute your measure name where I have [Ttoal Sales] and your figures like 1.8,1.7,or 1 where I have 50,30,and 1)

Test = IF([Total Score] > 50, [Total Score] * 5,

IF([Total Score] > 30, [Total Score] * 3, [Total Score] *1))