Filter question

[Anonymous]

Sorry if it is a dumb question but i have 3 columns, A , B and C, A row sometimes are empty and B rows sometimes are empty too, I want to filter in this way if A and B are both empty the row will not appear, but i dont know how.

[v-alq-msft · Accepted solution]

Hi, @Anonymous 

Based on your description, I created data to reproduce your scenario.
Table:

If you want a filtered table visual to display the result, you may create a measure as below.

Visual control = 
IF(
    OR(
      SELECTEDVALUE('Table'[A])<>BLANK(),
      SELECTEDVALUE('Table'[B])<>BLANK()
    ),
    1,0
)

Then you need to put the measure in the visual level filter to display the result.

If you want to create a new table, you may create a calculated table with the following formula.

New Table = 
FILTER(
    'Table',
    OR(
        'Table'[A]<>BLANK(),
        'Table'[B]<>BLANK()
    )
)

Result:

Best Regards

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[az38]

Hi @Anonymous 

try to create a new Table like

New Table = 
FILTER(Table,
NOT(ISBLANK(Table[Column A])) || NOT(ISBLANK(Table[Column B]))
)