Forum Discussion

Coryanthony's avatar
Coryanthony
Icon for Helper III rankHelper III
3 years ago

Filter 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 for the last 3 months.

 

Any help is greatly appreciated. Thank you 

 

 

 

 

Need Help

1 Reply

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    3 years ago

    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