Filtering based on two calculated columns using OR

[jcastr02]

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         Column B 

Yes                    No

No                    No

Yes                   No

Yes                   Yes

Yes                   Yes

[Anand24]

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]

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]

@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

[mahoneypat]

In the query editor, add a new custom column with a formula like this and then filter on it.

= if [Column A] = "Yes" or [Column B] = "Yes" then "Keep" else "Remove"

Pat

[jcastr02]

@mahoneypat   Thank you for help.   Since they are two calculated columns, they don't come up under the "available columns" for me to select from.  any guidance would be appreciated. 

[amitchandak]

@jcastr02 , Try a measure like

calculate(countrows(Table), filter(Table, table[Column A] = "Yes" || table[Column B] = "Yes"))

[jcastr02]

Hello @amitchandak   I tried that but all the values are coming up the same.  Looking for it to show "include" if Either column "Accept SLA late?"="yes"    OR "Fix SLA late?"="yes"   if not , Exclude...

[amitchandak]

@jcastr02 , I suggested a measure.

For a column 

if(table[Column A] = "Yes" || table[Column B] = "Yes" , "Include", "Exclude") // One is yes

or

if(table[Column A] = "Yes" && table[Column B] = "Yes" , "Include", "Exclude") // Both should be yes