
1. Re: Counting amount of invoice per customer
Patrick Weber Aug 29, 2016 5:24 AM (in response to Patrick Weber)I forgot to mention that the revenues are the results of a calculation.

2. Re: Counting amount of invoice per customer
Benjamin Greene Aug 29, 2016 5:53 AM (in response to Patrick Weber)Is the Revenue calculation an aggregate calculation? If so, in your Filter calculation, you could try something like IF {INCLUDE [Customer], [Invoice] : [Revenue]}<400 THEN 1 ELSE 0 END. This way, it would only perform that calculation on each invoice individually, rather than for all the invoices for a customer.
If your Revenue calculation is not an aggregate calculation already, then my guess is that your Filter calculation has a SUM([Revenue]) in it right now. If this is the case, just try removing the SUM part of it.

3. Re: Counting amount of invoice per customer
Patrick Weber Aug 29, 2016 6:18 AM (in response to Benjamin Greene)Yes the revenue calculation is already an aggregate calculation.
I tried it with your include condition but there is still the same behaviour.

4. Re: Counting amount of invoice per customer
Benjamin Greene Aug 29, 2016 8:32 AM (in response to Patrick Weber)I went ahead and mocked up your question in a sample dataset and came up with a solution. That is on sheet 3. Sheets 1 and 2 just show all the underlying data so that you can check to make sure the numbers are right. The only real difference is that I should have written FIXED instead of INCLUDE.

Book1.twbx 1.2 MB
