Related table in measure returns no value if one of the tables returns no rows

[Anonymous]

I have the following measure which works perfrectly when rows are reutned from both tables but when one table returns no rows there is no response not even "Blank".

I would like to in the event that one of the tables returns no rows  display "0".

Dax meaure

Test = Calculate(

          Countrows(tablea),

           Filter(relatedtable(tableb), and ([Status] = "In Stock", [substatus] = "Available")), tablea[object_type] = 12)

Tableb is not returning any rows as there is no match for [Status] = "In Stock", [substatus] = "Available"

Thanks

[_elbpower · Accepted solution]

VAR FilteredTableB = FILTER( RELATEDTABLE(tableb), [Status] = "In Stock" && [substatus] = "Available" ) RETURN IF( COUNTROWS(FilteredTableB) > 0, CALCULATE( COUNTROWS(tablea), FilteredTableB, tablea[object_type] = 12 ), 0 )