Forum Discussion
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...
Tahreem24
Super User
Super UserAnonymous 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_)
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_)