Find double creation of orders with Direct query?

[mikkelakabel]

How do I make a measure that returns the orders where one customer have created more than one order on a day?  

OrderId	CustomerId	Date
1	1	1
2	2	1
3	2	2
4	2	2

Should return

OrderId	CustomerId	Date
3	2	2
4	2	2

[amitchandak · Accepted solution]

@mikkelakabel , Try a measure like

measure =
var _1 = calculate(countrows(Table), allexcept(Table, Table[Customer], Table[Date]))
return
calculate(sum(Table[value]), filter( Table, _1 >=1))