Forum Discussion

VistaDee's avatar
VistaDee
Frequent Visitor
5 years ago
Solved

LEFT JOIN creating Duplicate in SUM

So I was wondering if I could get some help withi this:   I have 2 seperate tables: Projects ProjectID ProjectName ProjectCost 123456 Tilling Kitchen 150 545454 Painting Hallway ...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    VistaDee , You can create a join between these two assume projects has unique project only. 1-M join(No need to merge)

     

    a measure like this should have give you projects with no jobs too

    count(Jobs[ProjectID])+0

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

VistaDee , You can create a join between these two assume projects has unique project only. 1-M join(No need to merge)

 

a measure like this should have give you projects with no jobs too

count(Jobs[ProjectID])+0