Summing the numbers from measures

[Anonymous]

Hi All,

My issue is that I am unable to add up the highlighted numbers below to show the total of  €7,207

If I try with the following formula, it will count all the numbers above

Discounted_Total = [Discount1] + [Discount2]

Discount1 and Discount2 are measures and using the below logic;

(only difference are the highlighted numbers which represent the discount)

I was hoping to append the formula for discount1 and discount2 as follows but unfortunately the 'Country' field is not available, I can only choose measures, not fields.

Discount1 = If( country = "Irish Request",

VAR Total = [NoOfCalls]

VAR T1 = IF (Total >1000,1000, Total)

VAR T2 = IF ((Total >1000) && (Total <1500),Total - 1000, 500)

VAR T3 = IF (Total >1500,Total - 1500, 0)

VAR Cost = IF (Total >1000, T1*2 + T2 *1.7 + T3 *1.4, Total*2)

RETURN IF(ISBLANK(Cost),0,Cost)

Can you please help me to sum 4,108 and 3,099? Is there any function I could use?

 Thanks,

[tamerj1 · Accepted solution]

Hi @Anonymous 

you can try

Discounted_Total =
CALCULATE ( [Discount1], Table[Country] = "Irish Request" )
    + CALCULATE ( [Discount2], Table[Country] = "UK Request" )

[Anonymous]

thanks man! 🙂 I spent 5 hours today trying