Aggregated functions sum another dimension only distinct

Applicable88 — Tue, 23 Jun 2020 13:13:00 GMT

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([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([Serialnumber]), [Deliverynumber], distinct Position))

How can I only count this aggregation with the same Position distinct?

Thanks in advance.

Best.

Re: Aggregated functions sum another dimension only distinct

lironbaram — Mon, 22 Jun 2020 13:23:30 GMT

if you want to count it per Delivery and position , you can use : count(total<Deliverynumber,Position>Serialnumber)

if you want per delivery : count(total<Deliverynumber>Serialnumber)

Re: Aggregated functions sum another dimension only distinct

Sue_Macaluso — Mon, 22 Jun 2020 20:03:07 GMT

corrected.

topic Re: Aggregated functions sum another dimension only distinct in Visualization and Usability

Aggregated functions sum another dimension only distinct

Re: Aggregated functions sum another dimension only distinct

Re: Aggregated functions sum another dimension only distinct