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.

Fowmy's avatar
Fowmy
Icon for Super User rankSuper User
5 years ago

scottjl 

You can apply a filter as follows

FILTER ( 
   TABLE,
   TABLE[COLUMN A] = "YES" ||  TABLE[COLUMN B] = "YES"
)
  • scottjl's avatar
    scottjl
    Frequent Visitor
    5 years ago

    Sorry, newbie question, where do I go in desktop to apply that filter?

    • Fowmy's avatar
      Fowmy
      Icon for Super User rankSuper User
      5 years ago

      scottjl 

      Can you explain what you are trying to acheive? Do you need a table as output or need to apply filtering inside a measure? Better provide some sample data and the expected results.

      • scottjl's avatar
        scottjl
        Frequent Visitor
        5 years ago

        Sure. I have a gantt chart showing upcoming business opportunities that have a start and end date. The opportunity records in dynamics are all tagged priority "yes" or "no" and provide resources "yes" or "no". I want to only show the opportunities that are tagged priority "yes" or provide resources "yes". Priority and provide resources are 2 different columns in the table.