Forum Discussion
Measure Error With Many to Many Table Relationships?
Anonymous calculation looks correct, wihtout knowing underneath data, it is very hard to say why you will get weird result.
You want to drop all your measures in a table visual and work areas and see if you are getting correct number of sum of hours.
Anonymous calculation looks correct, wihtout knowing underneath data, it is very hard to say why you will get weird result.
You want to drop all your measures in a table visual and work areas and see if you are getting correct number of sum of hours.
parry2k One last thing (sorry for so many questions). I just checked the measure and the one calculating scheduled hours is filtered correctly on work area, but that might be because work area exists in the same table as scheduled hours. When I try to filter actual hours by work area, I am getting the same value for every one: the sum of all the hours worked in that table. Any pointers here?
Cross Filtering wasn't enabled :smileyhappy:
Anonymous no worries. Same thing you have to do, make another table of work area with unique values and set relationship between you schedule and actual tables , and everything will flow.