I have 2 tables in powerbi, one contains all transactions to and from people (each client identified with an id, where "I" can be either the receiver or sender of $) and the other is the detail for each client.

Table 1 would look something like

```
| $ | sender id | receiver id |
|---|-----------| ------------|
| 10|     1     |       2     |
| 15|     1     |       3     |
| 20|     1     |       2     |
| 15|     3     |       1     |
| 10|     3     |       1     |
| 25|     2     |       1     |
| 10|     1     |       2     |

```

The second table contains sender id and name:

```
| id | name  |
|----|-------|
|  1 | "me"  |
|  2 | John  |
|  3 | Susan |

```

The expected result is something like (not necesarily in a table, just to show)

```
| $ sent | $ received | Balance|
|--------|------------|--------|
|   55   |     45     |   +10  |

```

And in a filter have "John" and "Susan" so when i Select one of them i could see $ sent, $received and balance for each of them.

The problem of course is that i end up with one active and one inactive relationship so if i apply such a filter i end up with 0 in sender/receiver and the whole value in the other (depending which is made active and inactive) and if i make another table that's "id sender"+"name sender" then i cant filter all at once.

Is it possible to do this?
I hope this is kinda understandable