Calculate SUM from a related table?

[chad_oge]

I have a primary order table:

And a secondary parts table:

They are joined on Order:

When building a table from Orders and adding the sum of Qty, I get this:

My desired result is this:

I want to keep all orders from the original Orders table and ignore the Qty from non-matches.

Any help is appreciated!

[amitchandak]

@chad_oge ,because order 4 is not there.

Try "Show item with no data option" and chek

[chad_oge]

Hmm, that did solve my main issue, but on my actual project I had conditional fomatting applied to the table and only the rows with data now have the formatting..

[ryan_mayu · Accepted solution]

@chad_oge 

can meger table solve your problem? you can use table A left join table B.

[chad_oge]

Yes this will work! Thanks.

[amitchandak]

@chad_oge , blank will not have conditional formatting, I even tested with isblank in a color measure

+0 to a measure is an alternate, that gives 0 in place of blank

Sum(Table[Qty]) +0