IF Statement in a measure, Ignore IF blank

[astarkey]

I imagine this is quite easy fro someone in the know..... WOuld be very staright forward in excel

I have a measure as below

service margin = [service element] - (sum(RevenueCostAnalysisViaInvJobsTable[PartsCost])+sum(RevenueCostAnalysisViaInvJobsTable[TimeCost]))

but I want to add an IF statement to this along the lines of IF [serivce element] is blank or zero then this measure should also return zero.

At the moment it returns a large negative number if [service elemet] is blank or zero because it is minusing the remaininder of the measure which is incorrect.

Any help appreciated

[v-yuta-msft · Accepted solution]

Hi astarkey,

Modify your measure like this pattern:

service margin =
IF (
    [service element] = 0
        || [service element] = BLANK (),
    0,
    [service element]
        - (
            SUM ( RevenueCostAnalysisViaInvJobsTable[PartsCost] )
                + SUM ( RevenueCostAnalysisViaInvJobsTable[TimeCost] )
        )
)

Hope it's helpful to you.

Jimmy Tao