Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Sum values by ID

Hello!   I've following situation:   What I want to achieve is to aggregate values by QuantityID. 2 in 1st row and 3rd row is the same, there are no spaces or anything (I've putted it via E...
  • Anonymous's avatar
    Anonymous
    7 years ago
    [Column 2] =
var __quantity = T[Quantity]
var __sameQuantityCount =
	COUNTROWS (
		FILTER (
			T,
			T[Quantity] = __quantity
		)
	)
var __sameQuantitySum =
	__sameQuantityCount * __quantity
RETURN
	__sameQuantitySum

    Best

    Darek

Anonymous's avatar
Anonymous
Not applicable
7 years ago
[Column 2] =
var __quantity = T[Quantity]
var __sameQuantityCount =
	COUNTROWS (
		FILTER (
			T,
			T[Quantity] = __quantity
		)
	)
var __sameQuantitySum =
	__sameQuantityCount * __quantity
RETURN
	__sameQuantitySum

Best

Darek

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Thx Darek for quick answer, but I don't think this is what I was asking for.

 

What if I've let say 10000 rows with Quantity:

1

2

3

3

2

1

and so on...and I want to sum the quantity by each row. Not doing count though.

 

Cheers!

Michal