Aggregated functions sum another dimension only distinct

[Applicable88]

Aggregated functions sum another dimension only distinct

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. 

[Applicable88]

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. 

[fosuzuki · Accepted solution]

Hi,

try this:

count(total <Deliverynumber, Position> distinct Serialnumber)

Hope this helps.