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:

       

     

rohit1991's avatar
rohit1991
Icon for Super User rankSuper User
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:

     

 

  • josborne's avatar
    josborne
    Icon for Helper I rankHelper I
    11 months ago

    Thank you, this worked!