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

I think what I provided is correct.

 

Let me say why, In your product count grid, it is not counting empty (string) Produc ID. All these are part of the manager 2 schedule when you verify the data and are on 9/27. You can check the data tab.  You have empty Produc ID in your data.

 

In your Product Count visualization table, you are using default summarization by power bi and it takes only non empty Produc ID. 

 

You can verify using to match the counts:

Measure 3 = CountRows('Production Schedule')
 
What I used is CountRows in my formula! 
 
Tune to your requirements whether you want the empty Produc IDs or not!

 

sevenhills's avatar
sevenhills
Super User
4 years ago