Forum Discussion

Mark_Andersen's avatar
Mark_Andersen
New Member
5 years ago
Solved

Average age with DIM and FACT

Hi community   I have a problem calculate the average age per year and show it in a graph. Thanks for the help in advance.   DIM_Employee Employee ID Age 1 40 2 50 3 45 4...
Need Help
  • Mark_Andersen's avatar
    Mark_Andersen
    5 years ago

    Thank you for your reply. 
    The problem with sum('DIM_Employee'[Age]) is that it will sum employees with no match in FACT_Employee.

    I need something like total sum DIM_Employee[age] if employee ID match with FACT_employee ID / Distinctcount(FACT_Employee[Employee ID)

     

     

ryan_mayu's avatar
ryan_mayu
Icon for Super User rankSuper User
5 years ago

Mark_Andersen 

you can create a calendar table. Then create a measure

Measure = sum('DIM_Employee'[Age])/COUNTROWS(FACT_Employee)

please see the attachment.