Forum Discussion

amitchandak's avatar
amitchandak
Super User
2 years ago

SillySuzy , try like

 

Within90DaysPurchases =
var _max = calculate(Min(Sales[OrderDate]), filter(ALLSELECTED ( Sales ), Sales[CustomerKey] = MAX ( Sales[CustomerKey] ) ))
return
CALCULATE (
COUNTROWS ( Sales ),
filter( ALLSELECTED ( Sales ),
Sales[CustomerKey] = MAX ( Sales[CustomerKey] ) &&
Sales[OrderDate] > _max &&
Sales[OrderDate] < _max + 90
) )

SillySuzy's avatar
SillySuzy
Regular Visitor
2 years ago

I appreciate your help, but I cant use Filter(), sadly.