Forum Discussion
Product Count Based on Shift
- 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
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
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:
- sevenhills4 years agoSuper User
- markefrody4 years agoPost Patron
sevenhills
Sorry about that. Thank you for letting me know that there are empty fields on the data.
Thank you for helping me. It's working perfectly.
Best regards,
Mark V. - sevenhills4 years agoSuper User