Referencing a measure in DAX DATESBTWEEN function

[pretlow]

In Powerpivot 2013 I am trying to calculate unit sales per day between the last time an item was received and the last time it was sold, but I keep getting tripped up by the DATESBETWEEN fuction.
These measures return the dates of of the last recieve and last sale:
Lastsale:=CALCULATE(LASTDATE(InvDetail[Date]), InvDetail[Type]="Sale")
Lastrecv:=CALCULATE(LASTDATE(InvDetail[Date]), InvDetail[Type]="Receive", all(InvDetail[Date]))

This is what I'm using to get the units sold between the last receive and last sale, but it's not working. I don't get an error, just crazy big numbers.
UnitsSold:=calculate(sum(InvDetail[units]), InvDetail[Type]="Sale", DATESBETWEEN(InvDetail[Date], [Lastrecv], [Lastsale]))

If I hard-code in the dates as below, it works.
UnitsSold:=calculate(sum(InvDetail[units]), InvDetail[Type]="Sale", DATESBETWEEN(InvDetail[Date], date(2015,1,1), date(2015,2,1)))

I also have to get the number of dates in that date range too, but I haven't gone there yet.
Is there some reason why I can't use the measures in the DATESBETWEEN function?

 

[GDRIII]

Are you using a calendar table?

You need one for DAX Time intelligence to work.

Once you get one, change your InvDetail[Date} references to the date column in your calendar table.

 

[pretlow]

Yes, I do have a calendar table, but when I change the Lastsale measure to :=CALCULATE(LASTDATE(DateMasterX[DateKey]), InvDetail[Type]="Sale")
for example, I just get the last date in the calendar table regardless of the filters on the InvDetail table. All rows show the last date in the calendar table.

 

[PentaGalCXO]

gotta ask... did you identify the date table via Design/MarkAsDateTable ??? Time functions freak if you have not done this...

 

[scottsen]

Using the InvDetail on the LastSale/LastRecv measures seems... reasonable. But you can't do a DATESBETWEEN on that guy. That must come from the dates table. Time intelligence functions don't do "gaps"...