Forum Discussion
Coryanthony
Helper III
Helper IIIFilter on page/table measure
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 ...
amitchandak
Super User
Super UserCoryanthony, 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