How to filter Dates without changing values

[kristty1805]

Hello

I have this in the last 10 years but If I pick up in the last 3 years, some values are not including. 

if I put the last 3 years: The open values are not the same as in the last 10 years.

What I want, is to show all values.

I show you my formulas so maybe you can help me.

 this is for new

 this is closed

this is open 

 this is total closed and the most important is

 this is total. So here, I have the feeling that I have include something in my filters in order to show all values

Let me know if you have an a

[amitchandak]

@kristty1805 , Do you need open between open and close date, if yes, refer

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[kristty1805]

I need that the trends (open and total) don't change if I filter the last months.

[amitchandak]

@kristty1805 , In place all selected use all in measure and try

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.