Relationship - missing rows when adding column from another table

[Anonymous]

I have 2 tables (Table A and Table B) with a date and Hour column in each plus a Date table.

When I drag date from Date table in Table viz with hour from Table A and Table B it shows hours for April from Table A. 

when I drag Status column from Table B in the viz - April disappear as there are no April data in Table B.

How do I get April to appear on the "With status" viz?

[DAXRichArd]

Instead of having two fact tables (table A and table B), could you have a single fact table (table A B)? I don't have a solution by way of a DAX language. My first approach would be to denormalize the fact tables into one table. Looking at the available columns, you don't look like you have so much granularity that a single table becomes imposible to understand.

[LivioLanzo]

@DAXRichArd

the two tables are at a different granularities.. Table A is at the Date granularity whereas Table B is at the Date and Status granularity

[LivioLanzo · Accepted solution]

hI @Anonymous

try to add these two measures:

Total B Hours = SUM( TableB[Hours B])

Total A Hours = 
    IF( 
        NOT( ISINSCOPE( TableB[status] ) ),
        SUM( TableA[Hours A] )
    )