Forum Discussion
Average on total level from multiple measures
hi community, I want to generate the average Bradford ratio per individual and per company. I have made the following Dax measures: 1. Number of sickness cases in selected period (all sicknes...
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