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

WeihsMichael , Based on the condition which you have mentioned. Below code would be ideal:-

Column C = IF('ZV Vertrieb'[Aboumsatz] <> BLANK(),'ZV Vertrieb'[Aboumsatz VJ])
WeihsMichael's avatar
WeihsMichael
New Member
4 years ago

I changed the code line, but the total remains unchanged 😞

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

    WeihsMichael , Can you try this now:-

    Column C = IF('ZV Vertrieb'[Aboumsatz] <> BLANK(),'ZV Vertrieb'[Aboumsatz VJ],BLANK())

    still if it is not working then is it possible for you to share your PBIX after removing sensitive data?

    • WeihsMichael's avatar
      WeihsMichael
      New Member
      4 years ago

      Sorry, didn't work either. I´d love to share but editor has no such option to upload file, how can I share with you?

      • 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.