Forum Discussion
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...
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)
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)