Calculated column using Filter

[android1]

Hi,

I have a table called Users with columns FullName & UserType. I am trying to create a column

which displays all FullName when the UserType is Caregiver.

Getting the below syntax error when using this->

Carer Names = Users[FullName]
FILTER( Users,
[UserType] = "Caregiver")

The syntax for 'FILTER' is incorrect. (DAX(Users[FullName]FILTER( Users,[UserType] = "Caregiver"))).

[Anonymous · Accepted solution]

@android1  If this is a column and not a measure, it shouldn't need a filter. You're not filtering an entire table if you're going row by row in a column. This is a case for a simple IF statement.

Carer Names = IF(Users[UserType] = "Caregiver", Users[FullName], BLANK())

[android1]

Thank you, that works great.