Forum Discussion
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 ...
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.
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 !!! |