Dynamic age calculation

[Clemerson]

Good afternoon

I'm trying to make a dynamic age calculation, using a filter using a D_Calendar,I have a column with the date of birth, from it performed the age calculation 

"Dynamic Age = DATEDIFF([Birth Date],NOW(), YEAR)", it turns out that When I change the date filter indicated in the attached image that the age is also recalculated, Tried in several ways and could not, does anyone know how to do?

[Greg_Deckler]

@Clemerson Not sure what you are trying to do with the date slicer but if you don't want the birthday to change you could do this:

Dynamic Age Measure = 
  VAR __Name = MAX('Table'[Name]) // some identifier
  VAR __BirthDate = MAXX(FILTER(ALL('TAble'),[Name] = __Name),[Birth Date])
RETURN
  DATEDIFF(__BirthDate ,TODAY(), YEAR)

[Clemerson]

Thank you for your help,
Actually the date of birth I already have static

what I need is for dynamic age to change when I filter a different date

example: Today 09/26/2022 the age is 80, when put in the filter the date of 09/26/2023 the age would have to change to 81, I don't know if I could explain it right.

[Greg_Deckler]

@Clemerson So maybe this:

Dynamic Age = DATEDIFF([Birth Date],MAX('Table'[Date]), YEAR)