Forum Discussion
Average on total level from multiple measures
Hi, frankhofmans
You can try the following methods.
Average = Var _table=SUMMARIZE(ALL('Table'),'Table'[Employee ID],"Sum",[Bradford score])
Return
AVERAGEX(_table,[Sum])
Is this the result you expect? Please see the attached document.
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Charlotte,
this formula works, but i select a company (column "Company_Name" in Employee table), then the value doesn't change. How can i adjust this formula to get a average Bradford factor per company?
Many thanks,
Regards,
Frank
Hi, frankhofmans
Can you provide information on data that partially contains the name of the company?
Best Regards
hi,
i have two tables:
Table "Employments"
Employee_ID Employer_ID Startdate contract Enddate contract Table "Sickness cases"
Employee_ID Startdate sickness Enddate sickness I've calculated the number of unique employees with at least one working day in selected periode (from the employee_table) and the number of sickness cases and the total duration of the sickness cases per employee. I want to create the following table:
Employer_ID Average bradford factor E001 xxx E002 xxx When i use your formula, i get the same results on every row.
Thanks in advance,
Regards, Frank