Dynamic measure to display results for current year and previous 2 years

[Anonymous]

Hi, 

I have a measure which works fine but I want it to display the results dynamically for current year and last 2 years instead of me manually selecting the years 

Is it possible?

Heres my current measure:

1. DistinctAccount = DISTINCTCOUNT('AccountTable'[AccountId])

2. AccountMembers= CALCULATE(
[DistinctAccount],
FILTER(
ALLSELECTED('Calendar'[Date]),
('Calendar'[Date] <= MAX('Calendar'[Date]) 
))
,FILTER(ALLSELECTED(Id_Table[Termination Year]),(Id_Table[Termination Year]>SELECTEDVALUE('Calendar'[Year])))

Please let me know

Thanks

[v-piga-msft]

Hi @Anonymous,

---

I have a measure which works fine but I want it to display the results dynamically for current year and last 2 years instead of me manually selecting the years 

---

I'm not very clear about your requirement "display the results dynamically for current year and last 2 years instead of me manually selecting the years ".

Do you want your measure will show the value without selecting date in slicer?

If it is convenient, could you share some data sample and your desired output so that we could understand your scenario better and get the solution more quickly.

Best  Regards,

Cherry