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

sue110486

New Member
Joined
Nov 24, 2015
Messages
1
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
 

Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.

Forum statistics

Threads
1,223,098
Messages
6,170,106
Members
452,302
Latest member
TaMere

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top