Forum Discussion

nok's avatar
nok
Icon for Advocate II rankAdvocate II
1 year ago
Solved

Create 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...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • FarhanJeelani's avatar
    FarhanJeelani
    1 year ago

    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.
rsbin's avatar
rsbin
Icon for Community Champion rankCommunity Champion
1 year ago

nok ,

Your Calculated Column is:

SumID = CALCULATE( SUM([Value]),
           ALLEXCEPT( 'Table', 'Table'[ID] ))
 
Regards,