Forum Discussion
Return rows based on multiple IF conditions
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
Anonymous , 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")))
1 Reply
- amitchandak
Super User
Anonymous , 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")))