Forum Discussion
Formula help
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
4 Replies
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.
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)
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)
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)
