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

     

Anonymous's avatar
Anonymous
Not applicable
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

 

MouserMike's avatar
MouserMike
Helper I
7 years ago

Anonymous that's exactly what I was looking for. Thank you.