Forum Discussion

frankhofmans's avatar
frankhofmans
Icon for Helper IV rankHelper IV
2 years ago

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...
Need Help
frankhofmans's avatar
frankhofmans
Icon for Helper IV rankHelper IV
2 years ago

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

v-zhangti's avatar
v-zhangti
Icon for Community Support rankCommunity Support
2 years ago

Hi, frankhofmans 

 

Can you provide information on data that partially contains the name of the company?

 

Best Regards

  • frankhofmans's avatar
    frankhofmans
    Icon for Helper IV rankHelper IV
    2 years ago

    hi,

     

    i have two tables:

     

    Table "Employments"

     

    Employee_IDEmployer_IDStartdate contractEnddate contract

     

    Table "Sickness cases"

     

    Employee_IDStartdate sicknessEnddate 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_IDAverage bradford factor
    E001xxx
    E002xxx

     

    When i use your formula, i get the same results on every row.

     

    Thanks in advance,

     

    Regards, Frank