Forum Discussion

Helper V

6 years ago

Solved

Filter table where two columns contain data (OR)

I want to remove rows from a table visual where neither ColumnA OR ColumnB contain a value. How can I do this?

e.g. In this example row #3 would be filtered out from the table

you can create a calculated table in DAX

Tabelle 2 = FILTER(Tabelle,OR(Tabelle[ColumnA] <> BLANK(), Tabelle[ColumnB] <> BLANK()))

mwegener
Most Valuable Professional
6 years ago
Hi jdubs ,

you can create a calculated table in DAX

Tabelle 2 = FILTER(Tabelle,OR(Tabelle[ColumnA] <> BLANK(), Tabelle[ColumnB] <> BLANK()))
- jdubs
  Helper V
  6 years ago
  Thank you mwegener. That's exactly what I needed. Still getting the hang of this DAX stuff 🙂
jdbuchanan71
Super User
6 years ago
In power query you could add a column that combines your two, then delete rows where the check column is blank, then delete the check column.