sum column A based on values in column B

[WeihsMichael]

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 within the same table.

If you have suggestions, they are more than welcome.

Thx, Michael

[smpa01 · Accepted solution]

@WeihsMichael  you can write a measure like this

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

[WeihsMichael]

Thanks, tried but get a syntax error.

[smpa01]

@WeihsMichael  that is because you did not close parenthesis after 

SUM(tbl[column]

[WeihsMichael]

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

[smpa01]

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

[WeihsMichael]

https://noep-my.sharepoint.com/:u:/g/personal/m_weihs_noen_at/EYS2MEM-Kr1GvNJDv0BGEHsBEnaAYyTtQ0NDV-...

Does that work?

[WeihsMichael]

Can I send the pbix via email?

[smpa01]

@WeihsMichael  did not work

[Samarth_18]

Hi @WeihsMichael ,

You can create a new column with below code and use it instead:-

column = if(column B <> blank(),column A)

Thanks,

Samarth

[WeihsMichael]

Hi Samarth, thanks for posting the DAX line, it almost worked except for the total remaining unchanged. Maybe you have a clue?

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

[Samarth_18]

@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]

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

[Samarth_18]

@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]

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]

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

[WeihsMichael]

https://noep-my.sharepoint.com/:u:/g/personal/m_weihs_noen_at/EYS2MEM-Kr1GvNJDv0BGEHsBEnaAYyTtQ0NDV-...

Does that work?

[WeihsMichael]

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