Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
96 | |
79 | |
67 | |
62 |
User | Count |
---|---|
137 | |
106 | |
104 | |
81 | |
63 |