Can I use IF ISBLANK in a calculated measure?

[Anonymous]

I have a matrix with a column name "LA" that have some blank rows so I wanna replace them with 0. The thing is this column are a arelady a measure column that look like this

LA = CALCULATE([Rainbow];SAMEPERIODLASTYEAR(Calender[Date]))

How can I in same measure shown above use ISBLANK to repalce those blank rows with 0 ?

[AnthonyTilley · Accepted solution]

LA = 
var cal = CALCULATE([Rainbow];SAMEPERIODLASTYEAR(Calender[Date]))
var ret = if(cal = blank,0,cal)
return ret

[v-yuta-msft · Accepted solution]

@Anonymous ,

So LA is a measure , not a column, right? You can also modify your measure using dax below:

LA =
IF (
    ISBLANK ( CALCULATE ( [Rainbow]; SAMEPERIODLASTYEAR ( Calender[Date] ) ) );
    0;
    CALCULATE ( [Rainbow]; SAMEPERIODLASTYEAR ( Calender[Date] ) )
)

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[AnthonyTilley · Accepted solution]

LA = 
var cal = CALCULATE([Rainbow];SAMEPERIODLASTYEAR(Calender[Date]))
var ret = if(cal = blank,0,cal)
return ret