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
lbendlin's avatar
lbendlin
Super User
4 years ago

I don't see where sacks are uniquely linked to supervisors, so you likely experience double counting.  

 

Can you please explain the rationale behind your data model choices?

 

 

Usually you want to create a snowflake schema with dimensions and facts and 1:* relationships.

  • markefrody's avatar
    markefrody
    Post Patron
    4 years ago

    Hi lbendlin,


    Thank you for response. There is no unique link between the supervisors to sacks. The link is on the dates wherein:

    1. Supervisors
    Table: ​shift_supervisor_break_times
    Field: Plan Date Only

    2. Sacks production
    Table: sack_rail_details
    Field: Date Filled Date Only

    Both of these tables connect to a Date Table which contains "Date" field.