Forum Discussion

WeihsMichael's avatar
WeihsMichael
New Member
4 years ago
Solved

sum column A based on values in column B

Last column (3.754.621) should only total up values if column before (3.400.580) contains values (so the last 3 rows should not be part of the total, currently they are). Both data fields are w...
  • smpa01's avatar
    4 years ago

    WeihsMichael  you can write a measure like this

    _val2 = CALCULATE(SUM(t2[val2]),FILTER(t2,t2[val1]<>BLANK()))