Forum Discussion

markefrody's avatar
markefrody
Post Patron
4 years ago

Total Count in Measure Not Matching with Table Visual

Hi,   I have 2 managers wherein their production is measured on the number of sacks that are filled within their work shift excluding their break times.   I am using this measure to determine the...
Need Help
v-henryk-mstf's avatar
v-henryk-mstf
Community Support
4 years ago

Hi markefrody ,

 

I did the test and don't seem to understand the relationship between the tables created in your data model. I think there should be a one-to-many relationship between Date Table and sack_rail_details, which may be the reason for the wrong result of measure filtering.


Please answer my confusion, so that I can do further testing. Looking forward to your feedback.


Best Regards,
Henry


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

markefrody's avatar
markefrody
Post Patron
4 years ago

v-henryk-mstf 

 

Hi Henry,


Thank you for your response.

I have tried to update "one-to-many" relationship between the Date Table and sack_rail_details table but I am still coming up with the same results. The same is true with the "one-to-many" relationship between the Date Table and shift_supervisor_break_times table. I have made the relationship to the Date Table in order for the other tables have a common field to connect the data. 

I have now updated the relationship to "one-to-many" of Date Table to the other main tables in the link given. 

https://www.dropbox.com/s/l961nsj375rkvti/Sacks%20Filled%20Avg%20Rate%20.pbix?dl=0

Best regards,
Mark V.