Forum Discussion

BrianBollmann's avatar
BrianBollmann
Regular Visitor
7 years ago
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...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    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

mwegener's avatar
mwegener
Icon for Most Valuable Professional rankMost Valuable Professional
7 years ago

Hi,

 

I think you have to count the key column of the fact table.

 

Shift Count = DISTINCTCOUNT(fact_production[Date])
 
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.