Forum Discussion

jcastr02's avatar
jcastr02
Post Prodigy
5 years ago

Filtering based on two calculated columns using OR

I have two calculated columns with results either showing "yes" or "no" based on due dates.  How can I filter to show results that are Yes for column A   OR       Yes for Column B   Column A       ...
Need Help
Anand24's avatar
Anand24
Super User
5 years ago

Hi jcastr02 ,

 

You can simply create a measure with your conditions and then use it in filter.

Create new measure using below DAX:

Filter Measure = IF(MAX('Table'[ColumnA]) = "Yes" || MAX('Table'[ColumnB]) = "Yes",1,0)

 

Reference Image:

 

 

 

Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!!

Proud To Be a Super User !!!
LinkedIn
  • jcastr02's avatar
    jcastr02
    Post Prodigy
    5 years ago

    Hello Anand, thanks for the help  Anand24     See below.  I am seeing all of them are being included.... the one in red should not be included because they are both "no"         Looking for if either column is a Yes, then it should be included.  I appreciate any guidance.  

    • Anand24's avatar
      Anand24
      Super User
      5 years ago

      jcastr02 ,

       

      The DAX and method I mentioned in my first comment will give you result from the Report view.

      From your screenshot, you seem to be present at the Data View. You will need to create a calculated column to filter out.

       

      Step 1: Create Calculted Column using below DAX:

      Filter Column = IF('Table'[ColumnA] = "Yes" || 'Table'[ColumnB] = "Yes","Keep","Remove")

       

      Step 2: Filter new column with only "Keep"

       

      Reference Image:

       

       

      Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!!

      Proud To Be a Super User !!!
      LinkedIn