topic Re: Total sum error with sum filters in DAX Commands and Tips

Total sum error with sum filters

Anonymous — Fri, 16 Sep 2022 15:20:35 GMT

Hello everybody,

I'm having problems summing the total of the tables, I have 2 products that have 2 release dates, it was launched with a quantity on each date, then I need to know how its sales performance was, but for example, I have a sales total in a period 636 sales.

I'm using this measurement:

Varejo 4 Sem =

VAR DataLancamento = MAX(Lancamento_Vermelha[DT_Lançamento])

VAR DataMax = DataLancamento + 41

VAR DataMin = DataLancamento + 41

RETURN

CALCULATE(

[Venda Fisica],

DATESBETWEEN(Calendario[Data],MIN(Lancamento_Vermelha[DT_Lançamento])-41,MAX(Lancamento_Vermelha[DT_Lançamento])+41)))

Re: Total sum error with sum filters

tamerj1 — Fri, 16 Sep 2022 15:53:21 GMT

Hi Anonymous
Please try the following

Varejo 4 Sem = SUMX ( VALUES ( Lancamento_Vermelha[Material Pai] ), CALCULATE ( VAR DataLancamento = MAX ( Lancamento_Vermelha[DT_Lançamento] ) VAR DataMax = DataLancamento + 41 VAR DataMin = DataLancamento - 41 RETURN CALCULATE ( [Venda Fisica], DATESBETWEEN ( Calendario[Data], DataMin, DataMax ) ) ) )

Re: Total sum error with sum filters

Anonymous — Fri, 16 Sep 2022 17:13:58 GMT

It still hasn't happened, in fact I think the error is in the VAR DataLaunching, because if I put MAX, it brings me the value of 08/22/2021, and if I put the minimum it brings me the value of 11/15/2021 .

how do i return exactly then the date in question?

Re: Total sum error with sum filters

tamerj1 — Fri, 16 Sep 2022 17:17:34 GMT

Anonymous
would you please copy/paste the code so I can edit?

Re: Total sum error with sum filters

Anonymous — Fri, 16 Sep 2022 17:21:04 GMT

sorry, how do i do that? what code ?

Re: Total sum error with sum filters

tamerj1 — Fri, 16 Sep 2022 17:26:20 GMT

Anonymous
The [Varejo 4 Sem] measure. Please copy the dax formula and paste it in a reply so I can edit.

Re: Total sum error with sum filters

Anonymous — Fri, 16 Sep 2022 17:31:54 GMT

Atacado 4 Sem = VAR DataLancamento = MAX(Lancamento_Vermelha[DT_Lançamento]) VAR DataMax = DataLancamento + 28 VAR DataMin = DataLancamento - 41 RETURN SUMX( VALUES(Cadastro_Material[Material Pai]), CALCULATE( [Venda Fisica Atacado], DATESBETWEEN(Calendario[Data],MIN(Lancamento_Vermelha[DT_Lançamento])-41,MAX(Lancamento_Vermelha[DT_Lançamento])+28)))

so ?

Re: Total sum error with sum filters

tamerj1 — Fri, 16 Sep 2022 17:44:38 GMT

Anonymous

Please try

Atacado 4 Sem = SUMX ( SUMMARIZE ( Cadastro_Material, Cadastro_Material[Material Pai], Cadastro_Material[DT_Lancamento] ), CALCULATE ( VAR DataLancamento = MAX ( Lancamento_Vermelha[DT_Lançamento] ) VAR DataMax = DataLancamento + 28 VAR DataMin = DataLancamento - 41 RETURN CALCULATE ( [Venda Fisica Atacado], DATESBETWEEN ( Calendario[Data], DataLancamento, DataMax ) ) ) )

Re: Total sum error with sum filters

Anonymous — Fri, 16 Sep 2022 19:15:16 GMT

It kind of worked, but now when I talk about big dates it brings me a very large amount of the released,

Do I have to do something to that extent for it to get a filter?

Or for example, I have a release on 08/01/2022, so I go ahead and go back 41 days, which is between the period we did in the measure of DataMin, DataMax.

I just apply a filter of Year and month times.

On 01/08/2002 I launched 27800, but it is saying that I sold 282,924, even though the field Cadastro_Material[Material Parent] would be the product code.

I'm sorry for this.

Re: Total sum error with sum filters

tamerj1 — Sat, 17 Sep 2022 03:32:06 GMT

Anonymous

I'm sorry but I don't think I properly understand.

Re: Total sum error with sum filters

Anonymous — Mon, 19 Sep 2022 06:34:49 GMT

Hi Anonymous ,

Here are the steps you can follow：

1. Create measure.

Measure_Varejo 4 Sem = var _table1= SUMMARIZE('Lancamento_Vermelha','Lancamento_Vermelha'[DT_Lancamento],"Value",[Varejo 4 Sem]) return IF( HASONEVALUE('Lancamento_Vermelha'[DT_Lancamento]), [Varejo 4 Sem], SUMX(_table1,[Value]))

2. Result:

Best Regards,

Liu Yang

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