Forum Discussion
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...
WeihsMichael you can write a measure like this
_val2 = CALCULATE(SUM(t2[val2]),FILTER(t2,t2[val1]<>BLANK()))
Thx, changed it but strange things happened, some rows show wrong values now, some show no values at at 🙂
smpa01
Community Champion
Community ChampionWeihsMichael provide a sample pbix but uploading it in 1/g drive and share the link here
- smpa01
WeihsMichael did not work
Can I send the pbix via email?