Forum Discussion

markefrody's avatar
markefrody
Post Patron
4 years ago
Solved

Product Count Based on Shift

Hi,   I'm trying to count the number of products finished on each manager's time shift. Problem is each manager's shift changes every day.   I have two tables containing the following: Table ...
Need Help
  • sevenhills's avatar
    sevenhills
    4 years ago

    My bad, I misunderstood.
    I kept the same changes mentioned above and added a new measure and created new visual. Please see if this helps

     

    a) Created a measure part of manager schedule

     

    Prod Count = 

var _d1 = Minx('Manager Schedule', 'Manager Schedule'[Start Time])
var _d2 = Minx('Manager Schedule', 'Manager Schedule'[Clock Out])
var _Prod_count = CALCULATE( COUNTROWS('Production Schedule'), FILTER('Production Schedule', 'Production Schedule'[Date Finished] >= _d1 && 'Production Schedule'[Date Finished] <= _d2))

return _Prod_count

     

     

     

     

     

sevenhills's avatar
sevenhills
Super User
4 years ago

1. Create column as Date part only

 

Date Finished DT = DATEVALUE('Production Schedule'[Date Finished])

 

 

mark the format as "mm/dd/yyyy" to the new column

similar format to Manager schedule - start date column.

 

2. Adjust the model    and see if it works for your needs

 

 

See if this helps

 

 

  • markefrody's avatar
    markefrody
    Post Patron
    4 years ago

    sevenhills 

    Hi, 

    Thank you for your proposed solution but I need the count of products finished that is within the manager's respective schedule. 


    I have tried your proposed solution. It does not differentiate how many products where finished by each manager during the day. It shows the same count of products for Manager A and B for that day.

     

     

    • sevenhills's avatar
      sevenhills
      Super User
      4 years ago

      My bad, I misunderstood.
      I kept the same changes mentioned above and added a new measure and created new visual. Please see if this helps

       

      a) Created a measure part of manager schedule

       

      Prod Count = 

var _d1 = Minx('Manager Schedule', 'Manager Schedule'[Start Time])
var _d2 = Minx('Manager Schedule', 'Manager Schedule'[Clock Out])
var _Prod_count = CALCULATE( COUNTROWS('Production Schedule'), FILTER('Production Schedule', 'Production Schedule'[Date Finished] >= _d1 && 'Production Schedule'[Date Finished] <= _d2))

return _Prod_count

       

       

       

       

       

      • markefrody's avatar
        markefrody
        Post Patron
        4 years ago

        sevenhills 
        Hi,

        Thank you for the revision. It seems the total per day for 9/27/2021 is not the same as the calculated measure.

        Product Count


        Calculated Measure