Forum Discussion

scottjl's avatar
scottjl
Frequent Visitor
5 years ago
Solved

Filter multiple values from different columns

Hi,   I'm trying to filter my results where the value of column A is "yes" or the value of column B is "yes". Can someone help with the query?   Edit: It's a view back to a database and won't let...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi  scottjl ,

    This is the data I created:

    Here are the steps you can follow：

    1. Create measure.

    Measure =
IF(
    MAX('Table'[priority])="Yes"||MAX('Table'[resources])="Yes",1,0)

    Result:

    Now it shows that all data exist. Measure marks the unqualified data as 0 and the qualified data as 1

    2. Put measure into filter, set is = 1, and apply filter

    3. Result:

    Display the data that meet the requirements:

     

    Best Regards,

    Liu Yang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi  scottjl ,

This is the data I created:

Here are the steps you can follow：

1. Create measure.

Measure =
IF(
    MAX('Table'[priority])="Yes"||MAX('Table'[resources])="Yes",1,0)

Result:

Now it shows that all data exist. Measure marks the unqualified data as 0 and the qualified data as 1

2. Put measure into filter, set is = 1, and apply filter

3. Result:

Display the data that meet the requirements:

 

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.