topic Re: Calculate the sum within a a value in another column in DAX Commands and Tips

Calculate the sum within a a value in another column

renanc — Mon, 23 May 2022 21:03:45 GMT

Good afternoon everybody.

I would lilke to calculate the sum of the values in the column Valores_Preparacao, but only for the same plate. So for the rows with the plate ABL5H38, for example, I would like to have the sum only of that value, the same for ABL6J21, and so on.
Ps: For both these plates, the sum is the same, but is just a concidence, for the majority of the plates, the sum will be different.

Thanks in advance for any help.

Re: Calculate the sum within a a value in another column

Jihwan_Kim — Tue, 24 May 2022 03:19:58 GMT

Hi,

Please check the below picture and the attached pbix file.

I tried to create a sample pbix file like below.

It is for creating a calculated column.

Valor Somado CC = SUMX ( FILTER ( Data, Data[Coluna] = EARLIER ( Data[Coluna] ) ), Data[Valores_Preparacao] )

Re: Calculate the sum within a a value in another column

renanc — Tue, 24 May 2022 14:41:32 GMT

Thanks Jihwan_Kim, it worked!

Re: Calculate the sum within a a value in another column

renanc — Tue, 24 May 2022 15:01:51 GMT

Jihwan_Kim I have one more question, if you can help me, please
I just realized that there are some cases when the same car (the same value in the column Coluna) did different checklists, in different dates, and I have to Group By Coluna and DtCadastro (the Date of The Checklist).
I tried but the Dax return the message: Muitos argumentos foram passados para a função FILTER. Contagem máxima de argumentos para a função: 2. - Many Arguments were passed to Filter function. In the second image we can see that the plate ABL3F70 has some different values in the columns DtCadastro, so I would like to Group by the values of DtCadastro, in addition to Coluna.

Re: Calculate the sum within a a value in another column

Jihwan_Kim — Wed, 25 May 2022 02:49:05 GMT

Hi,

Please try the below calculated column.

Valor_Somado CC = SUMX ( FILTER ( 'tablename', 'tablename'[coluna] = EARLIER ( 'tablename'[coluna] ) && 'tablename'[dtcadastro] = EARLIER ( 'tablename'[dtcadastro] ) ), 'tablename'[valorespreparacao] )