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 :
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?