Subtract a value from a measure

[newgirl]

Hello!

In this report I'm developing, I've created lots of initial measures. The next measure I need is subtract 24 from a specific measure.

When I input 

Pack1_WorkingTim = 24 - fSolidPackhouse[Pack1_TotDowntime]

the matrix becomes wonky:

but if I replace it with another basic computation such as 1 multiplied by the measure, it works fine.

How should I write the dax measure to subtract 24 from the measure so that it would show properly in the matrix? 

[amitchandak · Accepted solution]

@newgirl , Try like

if(isblank([Pack1_TotDowntime]), blank(), 24 - fSolidPackhouse[Pack1_TotDowntime])

addition of value can force left join with dimension

[newgirl]

Hello @amitchandak  I'm having a similar situation but this time, i need an ouput of 1 if the condition is blank. How can I fix the measure?

Pack1_OperEff = IF(ISBLANK([Pack1_MachEff]*[Pack1_OperUtil]),1,[Pack1_MachEff]*[Pack1_OperUtil])

[newgirl]

Thanks @amitchandak ! It worked! Can you explain more about what you said "addition of value can force left join with dimension" ? I didn't know about this.