Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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 !!! |
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.
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 !!! |
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
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
@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.
@jcastr02 , Try a measure like
calculate(countrows(Table), filter(Table, table[Column A] = "Yes" || table[Column B] = "Yes"))
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...
@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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
100 | |
78 | |
75 | |
50 |
User | Count |
---|---|
144 | |
109 | |
108 | |
88 | |
61 |