Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Filter Common Names across 2 columns with a Disconnected Slicer - Problem

I have a problem that I feel like I'm getting closer to solving, but not quite. The goal is to have a single slicer, from a list of distinct managers that will filter a whole report based on if the p...
Need Help
  • mahoneypat's avatar
    mahoneypat
    6 years ago

    Did you wrap your QUI expression in an IF() like this? If the condition is not met, it must be blank and filtered by the visual (if not other measures that return present results).

    Return

    IF(OR( ... ), 1, BLANK())

    If this works for you, mark it as the solution. Praise is also appreciated. Please let me know if you don't.

    Best regards

    Pat

mahoneypat's avatar
mahoneypat
Icon for Microsoft Employee rankMicrosoft Employee
6 years ago

Did you wrap your QUI expression in an IF() like this? If the condition is not met, it must be blank and filtered by the visual (if not other measures that return present results).

Return

IF(OR( ... ), 1, BLANK())

If this works for you, mark it as the solution. Praise is also appreciated. Please let me know if you don't.

Best regards

Pat

Anonymous's avatar
Anonymous
Not applicable
6 years ago

You sir, are a genius. I had the OR, but had 0 rather than BLANK() as the false statement. Thank you!