DAX - Calculate Measure ONLY if another measure = 0

[Anonymous]

Hi there!

I have two measures, [Promo Vol] and [Total Vol] - you can see the results in this table

I just want to create another measure that will sum up the [Total Vol] but ONLY in cases where [Promo Vol] > 0

So in this case the output value I'm looking for is £334,948 (i.e. sum of everything in [Total Vol] except the last two rows because the Promo Vol is 0

Does anyone have any suggestions?

Thanks

Alex

[amitchandak · Accepted solution]

@Anonymous , Try a measure like

sumx(values(Table[Date]), if([Promo Vol] > 0, [Total Vol],blank()))

[Anonymous]

Legend, thank you! 😘