Count number of customer exceeding certain size

[MaBla2]

I'd like to count the number of customers exceeding a certain size of billings (KPI). Example: How many customers exceed a grand total of 50'000$ in billings in a given period?

I was able to count the number of OrderID exceeding a certain value but not the number of customer.

My raw data looks like this:

Year	Month	Customer	CustomerID	OrderID	Business Unit	Product	Qty	Billings
2015	3	A	10001	20001	X	a	1	4'000
2015	3	B	10002	20002	X	a	5	20'000
2015	3	C	10003	20003	Y	b	1	20'000
2015	4	B	10002	20004	Y	c	1	90'000
2015	5	C	10003	20005	Z	d	1	3'000
2015	5	A	10001	20006	Z	a	30	120'000
2015	6	D	10004	20007	X	e	1	280'000
2015	6	A	10001	20008	Y	f	1	10'000
2015	7	E	10005	20009	Z	g	2	22'000
2015	7	B	10002	20010	X	h	1	5'000
2015	8	F	10006	20011	Y	h	9	45'000
2015	9	E	10005	20012	X	d	10	30'000

Can anybody help me? 

[Anonymous · Accepted solution]

Something like:

Total Billings = SUM(MyTable[Billings])

High Value Customers =CALCULATE( DISTINCTCOUNT(MyTable[CustomerID]), FILTER ( VALUES(MyTable[CustomerId]), [Total Billings] > 50000) ) )

[BINoob0815]

Hello, is there a way to do this 12month rolling?

Thanks in advance.

Cheers

[MaBla2]

That is just perfect, thank you scottsen!