Calculated Column creating an empty slicer

[elinevans]

I have data that looks something the table below.

I have added a calculated column on this as follows: 

ClientCurrentAge = DATEDIFF(Client[DateOfBirth], Client[Today], YEAR)

However when I put this into a slicer visulisation it just comes up blank. Any advice?

 

Client ID	Date of Birth
1234	25/01/1998
3215	06/12/2005

[elinevans]

even if all the columns used in the measure are from the same table? 

[elinevans]

It's a part of a large databse and when I remove columns to hide sensitive data it then starts working. I wonder if it;s something to do with my relationships? Unfortunately I can't find a way to give you an example pbix file without sensitive data. 

[Kumail]

@elinevans 

Definitely, it is related to relationships.

Regards

Kumail Raza

LinkedIn: https://www.linkedin.com/in/kumail-raza-76508856/

[Kumail]

Hello @elinevans 

If you could send the sample .pbix file, it would help give you a quick solution.

Regards

Kumail Raza

[rocky09]

I have used the same DAX of yours. It is working for me.

Check if you have selected any of the data?

[rocky09]

Can you check if you have changed the Dateofbirth column to Date? I see, it might be existing as Text

[elinevans]

yes it's data type is Date