Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Add specific rows

Hi Folks,   I would like to add specific columns as shown in the below attached picture. For UID = 1, Values2 For UID = 2, Values 2 For UID =3, Values1+Values2 For UID =4, Values2 For UID =5, ...
Need Help
Show and Tell
Tips and Tricks
  • AlexisOlson's avatar
    AlexisOlson
    4 years ago

    Ah, I wasn't quite understanding where that number came from but I see now.

     

    Since it depends on a different row,  you'd need to do something a bit more like this:

    Calculated Column =
VAR _UID = TableA[UID]
VAR _Vals1 = TableA[values1]
VAR _Vals2 = TableA[values2]
VAR _Sum3 =
    SUMX (
        FILTER ( TableA, TableA[UID] = 3 ),
        TableA[values1] + TableA[values1]
    )
RETURN
    SWITCH (
        _UID,
        1, _Vals2,
        2, _Vals2,
        3, _Vals1 + _Vals2,
        4, _Vals2,
        5, _Sum3 + _Vals1 + _Vals2,
        _Vals2
    )

     

Tahreem24's avatar
Tahreem24
Super User
4 years ago

Anonymous Try this code:

Formula =
VAR value1_ = CALCULATE(SUM(TableName[Value]),TableName[UID]=1)
VAR value2_ = CALCULATE(SUM(TableName[Value]),TableName[UID]=2)
VAR value3_ = CALCULATE(SUM(TableName[Value]),TableName[UID]=3)
VAR value4_ = CALCULATE(SUM(TableName[Value]),TableName[UID]=4)
VAR value5_ = CALCULATE(SUM(TableName[Value]),TableName[UID]=5)
VAR value6_ = CALCULATE(SUM(TableName[Value]),TableName[UID]=6)
RETURN SWITCH(MAX(TableName[UID]),
1, value1_,
2,value2_,
3, value1_+value2_,
4, value4_,
5, value3_+value4_,
6, value6_)
 
Anonymous's avatar
Anonymous
Not applicable
4 years ago

 

Tahreem24 , I think you have got confused with one of my other post request. This post request is the summation across columns as well. 

 

The other post if only within the same columns but multiple selected rows.