Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Relationship - missing rows when adding column from another table

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 Ap...
Need Help
  • LivioLanzo's avatar
    LivioLanzo
    7 years ago

    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] )
    )
LivioLanzo's avatar
LivioLanzo
Solution Sage
7 years ago

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] )
    )