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.

 

UIDValueExpected ResultFormula for Math
1100100=Value(1)
22020=Value(2)
3 120=Value(1)+Value(2)
4200200=Value(4)
5 320=Value(3)+Value(4)
6750750=Value(6)

 

Thanks in advance. 

Need Help
Show and Tell
Tips and Tricks

12 Replies

  • Tahreem24's avatar
    Tahreem24
    Super 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
        Super User
        4 years ago

        Anonymous  Create the measure not column.

         

         

  • jaideepnema's avatar
    jaideepnema
    Solution Sage
    4 years ago

    Hi Anonymous ,

    Create a calculated column like this

    Expected Value = IF(ISBLANK(Data[Value]),CALCULATE(SUM(Data[Value]),Data[ID]<=EARLIER(Data[ID]),ALL(Data)),Data[Value])
     
    Where data is the table name of your dataset being used
     

    Please accept this as a solution if your question has been answered !!

    Appreciate a Kudos ğŸ˜€

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Thanks for your efforts. 

      I might have missed this. But, the summation is not always with EARLIER cell value or <= case.

       

      It could beRow 3= Row1+Row2,

      Row 9 = Row 2+Row7,

      Row 10 = Row7+ Row9