Forum Discussion

ytc-reports's avatar
ytc-reports
Icon for Helper I rankHelper I
9 years ago
Solved

Probably Extremely Easy Question - Sum Column on one Table from Matching Rows on Other Table

I have a question today that I think most of you will find quite easy, but I'm really struggling with.   I have an Item table, and each row on the Item table of course represents one Item. Each ite...
Need Help
  • Vvelarde's avatar
    Vvelarde
    9 years ago

    ytc-reports

     

    Use this and let me know if works

     

    QtySum = CALCULATE(Sum(TableB[Quantity]))

Vvelarde's avatar
Vvelarde
Icon for Community Champion rankCommunity Champion
9 years ago

ytc-reports

 

Use this and let me know if works

 

QtySum = CALCULATE(Sum(TableB[Quantity]))

ytc-reports's avatar
ytc-reports
Icon for Helper I rankHelper I
9 years ago

Vvelarde I think that may have worked! I feel so stupid, as that's so simple and I've used those things countless times before. I was just summing it, or trying to do calculate(sum and then putting a filter in there. I was overcomplicating it. Thanks so much!