Count of rows WHERE order date is in NEXT 7 days using DAX

[Anonymous]

Hi, I want to count number of customerid WHERE Order Date is in the NEXT 7 days.

How do I write this in DAX please ?

Many Thanks

[amitchandak · Accepted solution]

@Anonymous , Try a measure like

countrows(filter(Table, Table[Order Date] >=today() && Table[Order Date] <=today() +7))

or

countx(filter(Table, Table[Order Date] >=today() && Table[Order Date] <=today() +7),Table[customer_id])