Forum Discussion

aschillinger20's avatar
aschillinger20
Helper II
2 years ago

Issue with Measure using different data sources

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? 

Need Help

2 Replies

  • sergej_og's avatar
    sergej_og
    Super User
    2 years ago

    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's avatar
      aschillinger20
      Helper II
      2 years ago

      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.