Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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"))).
Solved! Go to 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())
Proud to be a Super User!
@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())
Proud to be a Super User!
Thank you, that works great.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
94 | |
77 | |
65 | |
53 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |