Show Blank as Zero based on two other columns

[Anonymous]

Hi Experts

I am trying to not show blank in my table (column QTY refunded) but replace those blanks with 0. See image below.

See Product Brooke should read 13 and 0 in the QTY Refunded Column not blank.

My measure is 

QTY Refunded = COUNTA('its_metapack_received_returns'[returnoption])

When i add +0 to the end i get the following . Its now showing a new Product BINKY which has no units order but QTY refunded as Zero. 

Ideally i want to only show Products that have Units Ordered and QTY Refunded as Zero not blank. 

[DataInsights · Accepted solution]

@Anonymous,

Try this measure:

QTY Refunded =
VAR vCount =
    COUNTA ( 'its_metapack_received_returns'[returnoption] )
VAR vResult =
    IF ( ISBLANK ( vCount ), 0, vCount )
RETURN
    vResult

[Anonymous]

Many Thanks, 

DataInsights