Forum Discussion

MouserMike's avatar
MouserMike
Helper I
7 years ago
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...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    MouserMike -

    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

     

littlemojopuppy's avatar
littlemojopuppy
Community Champion
7 years ago

Try something like this...

Impacted = 
IF (
    ISERROR (
        FIND (
            (SELECTEDVALUE ( 'DepartmentStakeholders'[Department] ) || 
            SELECTEDVALUE ( 'Projects'[PrimaryDepartment] )) &&
            SELECTEDVALUE ( Projects[ImpactedDepartments] )
        )
    ),
    0,
    1
)
MouserMike's avatar
MouserMike
Helper I
7 years ago

  • littlemojopuppy's avatar
    littlemojopuppy
    Community Champion
    7 years ago

    Lose the double ampersand and replace with a comma

    • MouserMike's avatar
      MouserMike
      Helper I
      7 years ago

      That removed the error, but now nothing is being returned when clicking a department in the slicer; results are always empty.

      • littlemojopuppy's avatar
        littlemojopuppy
        Community Champion
        7 years ago

        So I was never quite sure where you wanted the OR placed or if I had the field name correct.  The syntax should work and you should be very close...