Total value wrong in table

[Anonymous]

Hi all!!

I have this meansure bellow, when this mensure is in line is write, but the total value is wrong.

Someone know how could I do this ??

Thank so much,

VAR MaxDate = MAX(fEstoque[OrderDate])

VAR Result =

CALCULATE(

[Desvio Consumo] * [Custo Standard],

fMovimentacoes[OrderDate]<=MaxDate,

ALL( fMovimentacoes[OrderDate])

)

Return

Result

[Anonymous]

Isn't running write, I could with Sumx But it is very slowly

[ERD]

@Anonymous ,

You can try a bit another approach: https://community.powerbi.com/t5/DAX-Commands-and-Tips/DAX-Formula-Total-is-coming-0/m-p/1719572 

If this post helps, then please consider Accept it as the solution ✔️to help the other members find it more quickly.

[ERD]

@Anonymous , 

Performance of the measure is dependent on many factors: data model, the relationship of

tables, etc.

Try to read this: 

 Performance Tuning DAX - Part 1

[ERD]

Hi @Anonymous ,

The answer for this topic (incorrect totals for measures) can be found in this forum.

For example, Correct values, but wrong total .

If this post helps, then please consider Accept it as the solution ✔️to help the other members find it more quickly.

[Anonymous]

Its run, but i have a lot data so i cant't use Sumx because gonna be very slowly