A measure that sums values from two different columns based on a criteria

DAX DAX Calculations
1

Hi guys,

This might be real simple, but what I’m trying to achieve is creating a measure, that sums up values from two different columns, based on a criteria. Maybe a snippet of the data table will help :

image

What I want is to add the Old Total if Upgrade = No and Cancelled = No, or add the New Total if Cancelled = No and Upgrade = Yes.

Is this doable inside a single measure?

How can I achieve this?

Cheers!

2 
Measure = 
CALCULATE (SUM(Old Total), FILTER(<Table>, Upgrade ="No" && Cancelled="No") 
+ CALCULATE (SUM(New Total), FILTER(<Table>, Upgrade ="Yes" && Cancelled="No")
1 Like
3

Thank you, this solves the problem!