Remove lines with identical information in two different columns

[Orstenpowers]

Hopefully someone can help me with the following problem.

I did create a visualization (just a table) that also contains following columns

SalesOffices with Sales office country
IObOL new (incl K Group) with Country (Final ship to)

Now I would like to integrate a formula/ filter or whatsoever that filters all lines with identical countries for Sales office country and Country (Final ship to).

As an example, please see the screenshot. My idea is that only the highlighted ones should remain.

Is this possible? And how? I do not have any idea…

[Anonymous · Accepted solution]

Use following measure:

Measure= IF(SELECTEDVALUE('Table'[Column1])=SELECTEDVALUE('Table'[Column2]),1,0)

And use this measure into visual level filter and set this measure's value 0.

[Orstenpowers]

Thank you, it worked perfectly.