Measure to Calculate a sum across several related tables (Model/DAX)

[CliffordAP]

Hello all,

I have a small puzzle I am trying to understand. I have a relational database where GLs are attributed to products and services.

Here is the model I have so far, and the relationships I have modeled:

The best I can do with this setup is the following visual:

Since the balances for products and services are not on the same table, I cannot select them into the same column aligned with their respective GLs. Is there a way I can create a measure that will put these calculations into the same column?

What I have tried so far:

Here I attempted to see if it would only show the sum across the products and not the services. But it bloated everything instead.

I am looking for something like:

Is there a way I can accomplish this with a DAX measure? or is there some alternative method I can try in the model?
     *I would like to keep the product and service tables seperate from one another

     *I would like to attach the .pbix file with the model already in it, but I don't know how.
UPDATE:

I can get it to do exactly what I want in DAX Studio, but the DAX query does not have the same output in the desktop application. 

Thank you!

[CliffordAP · Accepted solution]

The filter context was activated in DAX Studio because the table argument was explicitly defined in the query. In Desktop it is not. Thus:

CALCULATE(SUM('Product'[Balance])+SUM('Service'[Balance]),'glFactTable')
Will work in PBI Desktop.

Thank you me!

Your Welcome.. Me.