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
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.
What is the error message?