Return rows based on multiple IF conditions

[BobKoenen]

HI all,

My Projecttable looks like this

Projectcode	type	Customer	Extra columns
A1	1	Jill	bla bla
A2	2	Jill	bla bla
A3	1	Joe	bla bla
A4	2	Joe	bla bla
A5	3	Joe	bla bla

Now I want DAX to return all rows where

Type <> 1 AND Customer = "Jull" 

Or

Type <> 2 AND Customer = "Joe"

The output should look like this in a table visual

ProjectCode	Type	Customer
A2	2	Jill
A3	1	Joe
A5	3	Joe

I hope you can help me

[amitchandak · Accepted solution]

@BobKoenen , add this measure along with other columns in a visual

calculate(countrows(Table), filter(Table, (Table[Type] <> 1 && Table[Customer] = "Jull") || ( Table[Type] <> 2 && Table[Customer] = "Joe")))