Skip to main content
cancel
Showing results for
Search instead for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Helper II

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

Go to My LinkedIn Page

Super User

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

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.

Go to My LinkedIn Page

4 REPLIES 4
Helper II

@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'[dtcadastro] = EARLIER ( 'tablename'[dtcadastro] )
),
'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.

Go to My LinkedIn Page

Helper II

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.

Go to My LinkedIn Page

## Helpful resources

Announcements

#### New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

#### Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

#### Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors