Adding values based on condition from two different columns

[n2p2gupta]

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

[Eric_Zhang · Accepted solution]

---

@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] )
)

[n2p2gupta]

Thanks Eric!