Calculate the sum within a a value in another column

[renanc]

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.

[Jihwan_Kim · Accepted solution]

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

[renanc]

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

[Jihwan_Kim · Accepted solution]

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

[renanc]

Thanks @Jihwan_Kim, it worked!

[Jihwan_Kim · Accepted solution]

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