topic Adding values based on condition from two different columns in Developer

Adding values based on condition from two different columns

n2p2gupta — Tue, 06 Jun 2017 14:54:27 GMT

I need to create a new column by looking up distinct values from "Bid Number" and "Class" and sum up the "bid value" in the new column. Any help is greatly appreciated.

for example: I want to create "Bid value total" column based on unique values where "Bid Number" & "class" are same.

Bid Number Bid value class Bid value total

151 10 a

151 10 a 20

151 10 b

151 5 b 15

152 10 b

152 20 b 30

Re: Adding values based on condition from two different columns

Eric_Zhang — Wed, 07 Jun 2017 02:26:44 GMT

n2p2gupta wrote:

I need to create a new column by looking up distinct values from "Bid Number" and "Class" and sum up the "bid value" in the new column. Any help is greatly appreciated.

for example: I want to create "Bid value total" column based on unique values where "Bid Number" & "class" are same.

Bid Number Bid value class Bid value total

151 10 a

151 10 a 20

151 10 b

151 5 b 15

152 10 b

152 20 b 30

n2p2gupta

You can either create a calculated column

bid value total colum =
CALCULATE (
    SUM ( yourTable[Bid value] ),
    FILTER (
        yourTable,
        EARLIER ( yourTable[Bid Number] ) = yourTable[Bid Number]
            && EARLIER ( yourTable[class] ) = yourTable[class]
    )
)

Or create a measure and put data in a Table visual.

bid value total measure =
CALCULATE (
    SUM ( yourTable[Bid value] ),
    ALLEXCEPT ( yourTable, yourTable[Bid Number], yourTable[class] )
)

Re: Adding values based on condition from two different columns

n2p2gupta — Thu, 08 Jun 2017 15:17:48 GMT

Thanks Eric!