Forum Discussion
markefrody
Post Patron
4 years agoProduct 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 ...
- 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 helpsa) 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
Ashish_Mathur
Super User
4 years agoHi,
Since you want the output to be date wise, I am assuming that the time stamp appearing in each of the 2 tables is not required.
- markefrody4 years ago
Post Patron
Ashish_Mathur
Hi Ashish,
Thank you for your reply.
For the output, time stamp is not required.
Best regards,
Mark V.- Ashish_Mathur4 years ago
Super User
Hi,
There should be another table which maps the products to managers.
- markefrody4 years ago
Post Patron
Ashish_Mathur
Hi Ashish,
I have created a pbix with date table to connect the tables together.
https://www.dropbox.com/s/mh1146kycg2hq1k/Product%20Count%20Based%20On%20Shift.pbix?dl=0
Please let me know if this helps. Thanks.
Best regards,
Mark V.