Forum Discussion
Measure Error With Many to Many Table Relationships?
Hello fellow PowerBI users! I am completely new to PowerBI and DAX programming, and I would like to know if many to many relationships are causing an issue. I have two separate tables in my model...
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: