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...
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)
