Forum Discussion
nok
Advocate II
Advocate IICreate column that sums all values with the same ID
Hello! I have a table that follows this structure: ID Value A 3 A 5 B 2 C 7 D 9 D 2 D 11 E 5 I want to create a new column that will sum the value of the...
Hi nok ,
You can achieve this by creating a calculated column in Power BI using DAX.
DAX Formula:
SUM_ValueById = CALCULATE( SUM('Table'[Value]), FILTER('Table', 'Table'[ID] = EARLIER('Table'[ID])) )
Please mark this as solution if it helps you. Appreciate Kudos.
FarhanJeelani
Super User
Super UserHi nok ,
You can achieve this by creating a calculated column in Power BI using DAX.
DAX Formula:
SUM_ValueById = CALCULATE( SUM('Table'[Value]), FILTER('Table', 'Table'[ID] = EARLIER('Table'[ID])) )
Please mark this as solution if it helps you. Appreciate Kudos.