Forum Discussion

josborne's avatar
josborne
Icon for Helper I rankHelper I
1 year ago
Solved

PowerBI - table join question

Hi all.  Hoping to get some advice, I just can't seem to work this out. I've got 2 tables: Table 1 - name ending in 'main' - primary data including project name and other details - contains 'proj...
Need Help
  • rohit1991's avatar
    rohit1991
    1 year ago

    Hi josborne 

    Could you please try below measure: 

    Total Effort = 
COALESCE (
    SUM ( Effort[EffortDays] ),
    0
)

    • SUM gives blank if no effort rows exist.

    • COALESCE converts that blank into 0.

      Outcome:

       

     

josborne's avatar
josborne
Icon for Helper I rankHelper I
1 year ago

Thanks all I really appreciate your help.  Let me clarify one thing if I may.  I'm adding the effort values from table 2 ('main') to table 1 ('effort). Some projects ('projectID' field) don't exist in table 2 because there is no effort against those projects. When I add the tables together into one visual (table or matrix) the projects which have no effort in the effort table are removed from the visual.  In other words, if I have 10 total projects and 5 have effort, my visual has all 10 projects until I add in the effort field then the visual only shows the 5 projects with effort.