How can I add two variables and return the sum?

[wpf_]

I have a measure that I want to add two variables:

Var Week1 = Calculate([traveltime minutes], Dateadd(table[date], -7, day))

Var Week2 = Calculate([traveltime minutes], Dateadd(table[date], -14, day))

Var Total = Week1 + Week2

RETURN Total

I do not get errors but it does not show in the matrix.  It shows if I return Week1 only.  

[erukulla_santh]

it actually changed the number in my case. just adding +0 worked for me better

[lkalawski]

Hi @wpf_ 

Please add All to the measure codes:

Var Week1 = Calculate([traveltime minutes],All(table), Dateadd(table[date], -7, day))

Var Week2 = Calculate([traveltime minutes], ALL(table), Dateadd(table[date], -14, day))

_______________
If I helped, please accept the solution and give kudos! 😀

[wpf_ · Accepted solution]

@lkalawski 

Thanks that helped me get to what i need!