Filter on a Powerpivot Table (Value field)

[shophoney]

Hi I'm trying to filter a list of items received.

I'm drawing the data from my POWERPIVOT. I have received items many times and need to know the # of weeks on the floor. Then I want to filter only items that are new IE first received in the last 4 weeks.

I've tried these with some adjustments. They do list the correct # of weeks. But I cant seem to filter them in the statement or on a table.

FIRST SENT TO STORES ALL:=CALCULATE(MAX('TRANSFERS'[FIRST SENT TO STORES]),ALL(tblInvSkuMaster[NON ZERO UNITS]))

FIRST SENT TO STORES ALL:=CALCULATE(MAX('TRANSFERS'[FIRST SENT TO STORES]),ALL(tblInvSkuMaster[NON ZERO UNITS]))

Really need some help here. So important to be able to review only new items. That have never been received.

Thanks