topic Re: Total value wrong in table in DAX Commands and Tips

Total value wrong in table

Anonymous — Fri, 23 Apr 2021 13:43:00 GMT

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

Re: Total value wrong in table

ERD — Fri, 23 Apr 2021 14:02:20 GMT

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.

Re: Total value wrong in table

Anonymous — Fri, 23 Apr 2021 16:06:47 GMT

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

Re: Total value wrong in table

Anonymous — Fri, 23 Apr 2021 18:59:33 GMT

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

Re: Total value wrong in table

ERD — Fri, 23 Apr 2021 19:16:35 GMT

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

Re: Total value wrong in table

ERD — Tue, 11 May 2021 08:56:59 GMT

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.