cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

## Adding values based on condition from two different columns

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

1 ACCEPTED SOLUTION
Microsoft Employee

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

2 REPLIES 2
Microsoft Employee

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

Frequent Visitor

Thanks Eric!

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

#### Fabric Community Update - August 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors