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:

       

     

mh2587's avatar
mh2587
Icon for Super User rankSuper User
11 months ago

Create following measure and put it into a table, you will have 0 instead of blank days which disappear or simple enble "Show items with no data" in table visual


Total Effort Days =
SUM('sw_pat_tbl_effort'[sw_effordays]) + 0