Forum Discussion

gregor's avatar
gregor
Frequent Visitor
9 years ago
Solved

Sum by Value in other Column

Hi,   I have a dataset that looks like this and I am trying to do the following:   I want to have the sum of all Values in (Column D)  when Column B = 'Income 1' e.g. for a certain ID-Number 1001...
  • v-huizhn-msft's avatar
    v-huizhn-msft
    9 years ago

    Hi gregor,

    Then you add [income] column in ALLEXCEPT function. 

    changed_Column = CALCULATE(SUM(Test1[Column D (Value)]),ALLEXCEPT(Test1,Test1[Column A (ID-Number)],Test1[Column B (Income)]))


    Please see the following screenshot.



    Best Regards,
    Angelia

v-huizhn-msft's avatar
v-huizhn-msft
Microsoft Employee
9 years ago

Hi gregor,

Then you add [income] column in ALLEXCEPT function. 

changed_Column = CALCULATE(SUM(Test1[Column D (Value)]),ALLEXCEPT(Test1,Test1[Column A (ID-Number)],Test1[Column B (Income)]))


Please see the following screenshot.



Best Regards,
Angelia

gregor's avatar
gregor
Frequent Visitor
9 years ago

Thank you so much  v-huizhn-msft this is exactly what I was looking for

 

Really appreciate it!