Forum Discussion
WeihsMichael
4 years agoNew Member
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...
- 4 years ago
WeihsMichael you can write a measure like this
_val2 = CALCULATE(SUM(t2[val2]),FILTER(t2,t2[val1]<>BLANK()))
WeihsMichael
4 years agoNew Member
Does that work?
smpa01
4 years agoCommunity Champion
WeihsMichael did not work