Total value wrong in table

Question

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]&lt;=MaxDate,ALL( fMovimentacoes[OrderDate]))ReturnResult

erd · Answer

Hi&nbsp;Anonymous&nbsp;,The answer for this topic (incorrect totals for measures) can be found in this forum.For example,&nbsp;Correct values, but wrong total&nbsp;.&nbsp;If this post helps, then please consider Accept it as the solution ✔️to help the other members find it more quickly.

anonymous · Answer

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

anonymous · Answer

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

erd · Answer

Anonymous&nbsp;,&nbsp;Performance of the measure is dependent on many factors:&nbsp;data model, the relationship oftables, etc.Try to read this:&nbsp;&nbsp;Performance Tuning DAX - Part 1

erd · Answer

Anonymous&nbsp;,You can try a bit another approach:&nbsp;https://community.powerbi.com/t5/DAX-Commands-and-Tips/DAX-Formula-Total-is-coming-0/m-p/1719572&nbsp;If this post helps, then please consider Accept it as the solution ✔️to help the other members find it more quickly.

Forum Discussion

Total value wrong in table

5 Replies

Related content

Wrong Total

Date Different return wrong value

Wrong Total in Table

Totals showing wrong value

Wrong total