cancel
Showing results for
Did you mean:
Helper I

## Calculate the sum within a a value in another column

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.

2 ACCEPTED SOLUTIONS
Super User

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]
)
``````

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

Super User

Hi,

Please try the below calculated column.

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

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

4 REPLIES 4
Helper I

@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.

Super User

Hi,

Please try the below calculated column.

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

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

Helper I

Thanks @Jihwan_Kim, it worked!

Super User

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]
)
``````

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

Announcements