Forum Discussion

josborne's avatar
josborne
Icon for Helper I rankHelper I
11 months 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
    11 months 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:

       

     

Anonymous's avatar
Anonymous
Not applicable
11 months ago
Hi josborne  ,

I would also take a moment to thank mh2587 , for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.
 

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions