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()))

     

     

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

WeihsMichael  you can write a measure like this

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

 

 

WeihsMichael's avatar
WeihsMichael
New Member
4 years ago

Thanks, tried but get a syntax error.

  • smpa01's avatar
    smpa01
    Icon for Community Champion rankCommunity Champion
    4 years ago

    WeihsMichael  that is because you did not close parenthesis after 

    SUM(tbl[column]
    • WeihsMichael's avatar
      WeihsMichael
      New Member
      4 years ago

      Thx, changed it but strange things happened, some rows show wrong values now, some show no values at at 🙂

       

      • smpa01's avatar
        smpa01
        Icon for Community Champion rankCommunity Champion
        4 years ago

        WeihsMichael  provide a sample pbix but uploading it in 1/g drive and share the link here