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...
Need Help
  • smpa01's avatar
    smpa01
    4 years ago

    WeihsMichael  you can write a measure like this

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

     

     

Samarth_18's avatar
Samarth_18
Icon for Community Champion rankCommunity Champion
4 years ago

If you dont have any issue in sharing then you can share it through one drive or google drive.

WeihsMichael's avatar
WeihsMichael
New Member
4 years ago

Sure. What's you email, I can share via OneDrive.