Forum Discussion
Solved
Average Pieces Per Shift
Attempting to get Average Pieces Per Shift. Dig, dig, dig, but haven't found the answer. Given a filtered list of detail production transactions, I need to summarize them by Date, Shift with a s...
HI BrianBollmann ,
According to your description and snapshot, I think you want to get the distinct count of the current group(year, month, shift), right?
If this is a case, you can try to use the following measure formula if it suitable for your requirement:
Shift count = CALCULATE ( DISTINCTCOUNT ( Table[Date] ), ALLSELECTED ( Table ), VALUES ( Table[Year] ), VALUES ( Table[Month] ), VALUES ( Table[Shift] ) )Regards,
Xiaoxin Sheng
HI BrianBollmann ,
According to your description and snapshot, I think you want to get the distinct count of the current group(year, month, shift), right?
If this is a case, you can try to use the following measure formula if it suitable for your requirement:
Shift count =
CALCULATE (
DISTINCTCOUNT ( Table[Date] ),
ALLSELECTED ( Table ),
VALUES ( Table[Year] ),
VALUES ( Table[Month] ),
VALUES ( Table[Shift] )
)
Regards,
Xiaoxin Sheng