cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
renanc
Helper I
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.

01.jpg

2 ACCEPTED SOLUTIONS
Jihwan_Kim
Super User
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.

 

Untitled.png

 

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


View solution in original post

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


View solution in original post

4 REPLIES 4
renanc
Helper I
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.

renanc_0-1653404374006.png

renanc_1-1653404436942.png

 

 

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


renanc
Helper I
Helper I

Thanks @Jihwan_Kim, it worked!

Jihwan_Kim
Super User
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.

 

Untitled.png

 

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
June 2022 update 768X460.jpg

Check it out!

Click here to read more about the June 2022 updates!

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Power BI Dev Camp Session 23 768x460.jpg

Check it Out!

Mark your calendars and join us on Thursday, June 30 at 11a PDT for a great session with Ted Pattison!

June 20 episode 7 with aka link 768x460.jpg

The Power BI Community Show

Join us on June 20 at 11 am PDT when Kim Manis shares the latest on Azure Synapse analytics, the Microsoft Intelligent Data Platform, and notable Power BI Updates from Microsoft Build 2022.

Top Solution Authors