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
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