Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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:
gives me an erroneous calculation
Thank you
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)
@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.
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
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)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
85 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |