Formula help

[Syndicate_Admin]

Hello Community, I hope you are well...

I tell you my problem in summary form:

1. I need to generate a simple calculation. I try to do it but it does not calculate well, I have this example case:

# The company FLSMIDTH has 3 accidents with injured people and 902,343 hours worked, so they ask me to calculate an accident rate, which is calculated as follows 3 (accidents)* 1000000 (average hours per year) / 902343 (hours worked. As a result it gives 3.32

# to extract the hours worked I have this database (I attach only a part, since there are many companies):

# when performing the calculation with the following formulas:

• (Formula to extract the hours) HH_EECC = CALCULATE(COUNTROWS('BD_Horas EECC'),'BD_Horas EECC'[Year]="2021")

• (formulate to perform the calculation) IF_EECC = ([CTP]+[FATAL])*1000000/[HH_EECC]
  • CTP Refers to Accidents with Injury
  • Fatal refers to accidents with deceased

gives me an erroneous calculation

Thank you

[Syndicate_Admin]

and change the formula as you recommended HH_EECC = sum('BD_Horas EECC'[HH]),however when making the calculation IF_EECC = ([CTP]+[FATAL])*1000000/[HH_EECC] still gives me an erroneous result (0.35) remember that the value that I should deliver is 3.32, considering the data delivered previously (3 * 1000000 / hh)

[Syndicate_Admin]

Exactly, the HH columa contains the number of hours. What I need is that the formula performs the calculation correctly, since when making this formula: IF_EECC = ([CTP]+[FATAL])*1000000/[HH_EECC], where I add the accidents with injury (CTP + FATAL) I multiply it by 1,000,000 (this is a factor of the formula that should not be eliminated) and by dividing by the hh (hours), should result in 3.32, considering the data provided above (3*1000000/hh)

[AllisonKennedy]

@Syndicate_Admin @Anonymous 

Does your HH column contain the number of Hours? Do you need to SUM that? You're doing a COUNTROWS. 

Try changing your Hours measure to: 

HH_EECC = SUM('BD_Horas EECC'[HH])

Note I removed the 2021 filter -I'd do that more dynamically using Slicers or other method, rather than hard coding it into the DAX.

[Syndicate_Admin]

and change the formula as you recommended HH_EECC = sum('BD_Horas EECC'[HH]),however when making the calculation IF_EECC = ([CTP]+[FATAL])*1000000/[HH_EECC] still gives me an erroneous result (0.35) remember that the value that I should deliver is 3.32, considering the data delivered previously (3 * 1000000 / hh)