Check for Duplicate and Sum the values

[gssarathkumar]

Hello, I have a below table.

Date	ID	Status
08-05-2024	1234	10
08-05-2024	1234	20
08-05-2024	4321	25
07-05-2024	123456	100

I need to create the below logic:

Check if the ID is same, if so sum the status of the job ids.

I created the Duplicate column using the below DAX, and now I stuck on creating the New Column.

Duplicate =
VAR CurrentText=Data[ID]
VAR _count = COUNTROWS(
FILTER(
'Data',
Data[ID]=CurrentText
)
)
RETURN
IF(_count>=2, true, false)

My expected output is as below:

Date	ID	Status	Duplicate	New Column
08-05-2024	1234	Committed	TRUE	30
07-05-2024	1234	Running	TRUE	30
08-05-2024	4321	Failed	FALSE	25
07-05-2024	123456	Killed	FALSE	100

Kindly help me on this solution

@amitchandak , @Greg_Deckler @lbendlin , @DesktopOwl @Goodlytics4U @help Ahmedx @Ahmedx @lbendlin @v-huijie-msft 

[ryan_mayu · Accepted solution]

@gssarathkumar 

you can create columns

Column =

VAR _count=CALCULATE(count('Table'[ID]),ALLEXCEPT('Table','Table'[ID]))

return if (_count>=2,TRUE(),FALSE())

Column 2 = CALCULATE(sum('Table'[Status]),ALLEXCEPT('Table','Table'[ID]))