Newbie-countrows distinct by month and customer where sales >0

[sue110486]

I am new to power pivot, I am trying to create a measure to calculate distinct customers buying per month where the total sales for the month and grand total are greater than 0.

eg. Customer A buys in July 1000 units count would be 1, in august a credit is raised for 1000 units august count = 0, grand total = 0
this is the formula I have so far based on 2 measures

UNIQCOUNT =CALCULATE(COUNTROWS(DISTINCT(SalesFY[SellToCustomerNo])))

CALCULATE([UNIQCOUNT],FILTER(SalesFY,SalesFY[Units]>0))

I have tried to sum of sales and sumx of sales in the 2nd measure I could not get either of them to work
Any assistance much appreciated

 

[Matt Allington]

I answered this same question here PowerPivot Forum • View topic - Distinct count by customer and month