Power BI show only rows with blanks in one table

[Anonymous]

I have a dataset with a few blanks in different columns. I wanted to showcase these blanks in a simple table. But it only lets me filter one column and doesnt show the blanks in other columns. for example:

column 1	column 2	column3
	value	value
value	value	value
value	value	value
value	value
value

If I filter column 1 on only show blanks. It only shows the first row. But I want to see all the blank in one table. Is there a way to do this with DAX?

What I want to see is this:

column 1	column 2	column3
	value	value
value	value
value

[Akash18]

This the the best solution.

[v-easonf-msft · Accepted solution]

Hi, @Anonymous 

You can create a measure as below, then apply it to 'Filters on this visual'

visual filter =
IF (
    ISBLANK ( MAX ( 'Table'[column1] ) ) || ISBLANK ( MAX ( 'Table'[column2] ) )
        || ISBLANK ( MAX ( 'Table'[column3] ) ),
    1,
    0
)

Best Regards,
Community Support Team _ Eason

[parry2k]

@Anonymous it is not clear what you are trying to achieve? What you mean by when filter column 1, you get to see blank in other columns and why filtering on column 1 will show only 3 rows whereas in your sample data it has 5 rows?