How to not show rows that have Field1=SOMETHING1 and Field2=SOMETHING2?

[UsePowerBI]

Hello

I have a table visual with several fields/columns.

I want not to show rows where Field1=SOMETHING1 and Field2=SOMETHING2.

I cannot do that with the visual filters at the right pane. Is there any other solution?

I tried to write a measure but it does not work:

Table filtered = FILTER(Table1,NOT(CONTAINSSTRING(Table1[Col2],"SOME TEXT")) && Table1[Col3]<>"OTHER TEXT")

Thanks!

[v-lionel-msft · Accepted solution]

Hi @UsePowerBI ，

Try to create a measure like this and add it to the filter window on the right.

Filter = 
IF(
    MAX('Table'[field1]) = "something1" && MAX('Table'[field2]) = "something2",
    1, 0
)

Or try to a measure like this.

// Add the measure to the table visual
Measure = 
CALCULATE(
    SUM('Table1'[field]),
    FILTER(
        ALL('Table1'),
        'Table1'[Col2] <> "SOME TEXT" && 'Table1'[Col3] <> "OTHER TEXT"
    )
)

Best regards,
Lionel Chen

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

[amitchandak]

@UsePowerBI , is there any other measure. if this only measures in visual it should show that. If there are more you should see blank value for this column