Filter on page/table measure

[Coryanthony]

Hello,

Please help with a filter measure. If "Overclaimed $ " is $75-$250 within the last 3 months, then i want to see it. 

I only want to see the employees that "Overclaimed $ " is $75-$250 total for the last 3 months.

Any help is greatly appreciated. Thank you 

[amitchandak]

@Coryanthony, Create following measures, Assuming you are using date tbale 

Rolling 3= CALCULATE([Overwrite claim],DATESINPERIOD('Date'[Date],MAX('Date'[Date]),-3,MONTH)) 

Between Range = sumx(Values(Table[Employee]), if ([Rolling 3] >=75 && [Rolling 3]< 250, [Rolling 3] , blank() ))

Rolling Months Formula: https://youtu.be/GS5O4G81fww