My Bad... i didn't give enough information about the table. Your Formula is working with the information given...
Unfortunately i forgot to mention that my table has a lot more fields like month, year...
So when i make a Chart with -
Dimensions: Buyer, FaktureMonth
Expressions: Count(DISTINCT Aggr(If(Sum(NETO) > 0,[Šifra artikla]),Komercijalist,[Šifra artikla]))
As long i select(Filter) only one month to display, your Formula works and gives me the correct amount. But if i select more months the number changes and is now wrong. Can you adjust the formula to work with filtered dimensions?
wrong amounts(4 months selected):
Correct amounts (month by month)
I appreciate your help, thank you