Forum Discussion
Measure total incorrect
What I mean was the calculation is done on eth measures which are not visible in the example. (It became -- the same)
I think I still need more information to help. But if the problem is that you are doing an operation which has two levels of operations. Sum till one place and product post that values can help
Try
if( HASONEFILTER(time_entries[Equipment Name (from Gsheet)]), [Dias Operativos Measure] * [Arriendo diario], sumx(values(time_entries[Equipment]), [Dias Operativos Measure] * [Arriendo diario])) sumx(values(time_entries[Equipment]), [Dias Operativos Measure] * [Arriendo diario])
What I mean was the calculation is done on eth measures which are not visible in the example. (It became -- the same)
I think I still need more information to help. But if the problem is that you are doing an operation which has two levels of operations. Sum till one place and product post that values can help
Try
if(
HASONEFILTER(time_entries[Equipment Name (from Gsheet)]),
[Dias Operativos Measure] * [Arriendo diario],
sumx(values(time_entries[Equipment]),
[Dias Operativos Measure] * [Arriendo diario]))
sumx(values(time_entries[Equipment]),
[Dias Operativos Measure] * [Arriendo diario])
amitchandak , fantastic! Adding the VALUES to the SUMX formula did the trick. I cannot really explain why at the moment, but it works which is what counts. I will chew on the why and how later. Thanks a lot for your help!