How to display 0 instead of blank when related record count is 0

[lkay]

Hello powerbi community, 

I'm trying to display a 0 value instead of blank, when record count from a related table does not give any values. 

Ex. Table 1 (Parent) has no related records in Table 2 (Child), so count is blank. But, id like to show 0's in a matrix table or visual. 

Ex. Adults (Table 1) who dont have kids (Table 2)

I tried creating a measure in Table 1 that says, but It didnt give me a proper result:

IF ( ISBLANK (CALCULATE ( COUNTROWS(RELATEDTABLE(Table2)))), 0 , CALCULATE ( COUNTROWS(RELATEDTABLE(Table2))

Any suggestions on what to do here?

Thank you

[lkay · Accepted solution]

The original formula worked with a column instead of a measure. Still learning the difference...

[lkay]

@VijayP thank you. I tried putting a +0, but it did not work. 

I tried:

IF ( ISBLANK (CALCULATE ( COUNTROWS(RELATEDTABLE(Table2)))), 0 , CALCULATE ( COUNTROWS(RELATEDTABLE(Table2)) +0

How can one show that ID #1 from Table 1 has 0 (NOT BLANK!) records from child Table 2. There must be a way.

I've been turning around in circles. 

Thanks,

[VijayP]

@lkay 

After entire formula just add  +0 , you will get required result

[omikeyz]

many thanks

Order Type ZMO1 (count) =

COUNTROWS(

    FILTER(

        WorkOrders,

        WorkOrders[ordertype] = "ZM01"

    )

)+0

// added +0 to return 0 instead of seeing "Blank"