Issue with Measure using different data sources

[aschillinger20]

I'm struggling with an issue that i'm guessing has a simple solution:

I need to create a measure that is called "Adjusted Hours" which would reflect hours created - hours canceled. Each are in their own data sets. I've tried using a measure in both data sets canceled hours=Sum('dataset'[hour qty] & created hours=SUM(dataset[hour qty]. Then a separate measure that's simply adjusted hours=completed hours - canceled hours. 

My result seems to be correct until I filter it between my two locations, and in that case the filter doesn't seem to do anything. 

Any ideas? 

[sergej_og]

usually it is a sign to check your data model (relationships etc.) when results get broke after adjusting a simple filter.

It can help when you show your data model. pls do not provide any confidential data

[aschillinger20]

The results are necessarily breaking, they just arent responding to the filter. Basically both locations that I have are subtracting the total of 200 canceled hours. I need one locations to subtract 175 and the other to subtract 25. For some reason both locations are subtracting 200. I tried to tie my source locations together in the data model, but it gives me a cardinality error and wont let me save.