Filter table where two columns contain data (OR)

[jdubs]

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

Row #	ColumnA	ColumnB
1	X
2		X
3
4	X	X

[mwegener · Accepted solution]

Hi @jdubs ,

you can create a calculated table in DAX

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

[jdubs]

Thank you @mwegener. That's exactly what I needed. Still getting the hang of this DAX stuff 🙂

[jdbuchanan71]

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.