Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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.
Solved! Go to 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]
)
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.
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.
@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.
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.
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.