Forum Discussion
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 th...
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
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.