Forum Discussion
Solved
Add OR to a Measure
I created a slicer along with a custom measure to allow me to filter a visual based on whether a particular field contained the value selected in the slicer. Below is the formual for the measure: Im...
Try something like this:
Your Measure = var a = FIND(SELECTEDVALUE('DepartmentStakeholders'[Department]),SELECTEDVALUE('Projects'[PrimaryDepartment]),1,0) var b = FIND(SELECTEDVALUE('DepartmentStakeholders'[Department]),SELECTEDVALUE('Projects'[ImpactedDepartments]),1,0) return MIN(MAX(a,b),1)Hope this helps,
Nathan
Try something like this...
Impacted =
IF (
ISERROR (
FIND (
(SELECTEDVALUE ( 'DepartmentStakeholders'[Department] ) ||
SELECTEDVALUE ( 'Projects'[PrimaryDepartment] )) &&
SELECTEDVALUE ( Projects[ImpactedDepartments] )
)
),
0,
1
)That is generating an error on the closed parenthesis after the last SELECTEDVALUE statement:
The double pipe - || - is the OR operator and the double ampersand - && - is the AND operator. Check the parenthesis that everything is properly closed...
I checked and double-checked and as far as I can tell, everything is closed. I don't understand how the || and && fit into the formula, but it seems to behave like there is a missing argument.
Lose the double ampersand and replace with a comma
That removed the error, but now nothing is being returned when clicking a department in the slicer; results are always empty.
