Forum Discussion

bernate's avatar
bernate
Icon for Helper III rankHelper III
1 year ago
Solved

Measure to show all rows in table visual when other table doesn't have those values

Hello! I have 2 tables: Employees and Hours. I am trying to make a table visual to show Employees and their Hours Worked.    Emplopyees are connected to Hours with Many-to-One on Employee ID, with ...
  • danextian's avatar
    1 year ago

    Hi bernate 

     

    You can add 0 to a measure to force Power BI to show all rows. Example SUM('Hours'[Hours]) + 0

    Or you can enable Show items with no data