Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Add cell value of multiple rows in same column

Hello,   Can someone throw some light on the implementation of the below scenario.   UID Value Expected Result Formula for Math 1 100 100 =Value(1) 2 20 20 =Value(2) 3   12...
Need Help
Show and Tell
Tips and Tricks
Tahreem24's avatar
Tahreem24
Icon for Super User rankSuper User
4 years ago

Anonymous  Try this measure:

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

    Sorry to trouble you. Am I doing anything wrong here? I am unable to get the same value as you get.

     

    Formula =
    VAR value1_ = CALCULATE(SUM(TableZ[Value]),TableZ[UID]=1)
    VAR value2_ = CALCULATE(SUM(TableZ[Value]),TableZ[UID]=2)
    VAR value3_ = CALCULATE(SUM(TableZ[Value]),TableZ[UID]=3)
    VAR value4_ = CALCULATE(SUM(TableZ[Value]),TableZ[UID]=4)
    VAR value5_ = CALCULATE(SUM(TableZ[Value]),TableZ[UID]=5)
    VAR value6_ = CALCULATE(SUM(TableZ[Value]),TableZ[UID]=6)
    RETURN SWITCH(MAX(TableZ[UID]),
    1, value1_,
    2,value2_,
    3, value1_+value2_,
    4, value4_,
    5, value3_+value4_,
    6, value6_)

     

     

     

     

    • Tahreem24's avatar
      Tahreem24
      Icon for Super User rankSuper User
      4 years ago

      Anonymous  Create the measure not column.

       

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        If its a measure, I get the same values.