Forum Discussion

SvenP's avatar
SvenP
Frequent Visitor
6 years ago
Solved

Measure total incorrect

Hi everybody,   I am aware that there are hundreds of posts on the topic "total of measure is incorrect" and I have read most of them. Yet, I cannot solve a rather simple issue: Equipment Name ...
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

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