Filter for a chart

[Anonymous]

Hello !!

I have this small example including products and their actual stock value. As I am only interested in those products, where the sum of all stock values is lower than 0, I would like to have the rows with positive values eliminated. How can I do that ?

Thanks a lot, Sascha

[jerem1234 · Accepted solution]

Try:

Sum({<Product = {'=sum([On Stock])<0'}>}[On Stock])

Hope this helps!

[jerem1234]

You can also use:

if(Sum([On Stock])<0, Sum([On Stock]))

[Anonymous]

Thanks a lot, worked fine.