Hello,
I have a table like this :
| Serialnumber | Timestamp | Position | Deliverynumber |
| BF33333 | 06.05.2020 | 10 | 11111111 |
| BF33334 | 06.05.2020 | 10 | 11111111 |
| BF33335 | 06.05.2020 | 10 | 11111111 |
| BF33336 | 06.05.2020 | 20 | 11111111 |
| BF33337 | 06.05.2020 | 20 | 22222222 |
| BF33338 | 07.05.2020 | 30 | 33333333 |
| BF33339 | 07.05.2020 | 30 | 33333333 |
| BF33340 | 07.05.2020 | 30 | 33333333 |
| BF33341 | 07.05.2020 | 30 | 33333333 |
| BF33342 | 07.05.2020 | 30 | 33333333 |
The Serialnumber is unique, a delivery can contain more than one serialnumber and a serialnumber can belongs always to a group of position. Also the date of the package can be on two different days.
I now just want to add a colllumn with the measure where I can see in each line how many Serialnumbers a specific delivery contains. The date can be disregarded.
I used something like this:
=sum(aggr(count([Meldung-Serialnumber]), [Deliverynumber], Position))
But since there are many positions, i only want to count each of the position distinct.
And something like this doesn't work out:
=sum(aggr(count([Meldung-Serialnumber]), [Deliverynumber], distinct Position))
How can I only count this aggregation with the same Position distinct?
Thanks in advance.
Best.
