cancel
Showing results for
Did you mean:
Highlighted
Helper III

## Calculated column Sumif with multiple criteria from multiple tables.

Hey guys,

I've been trying something but sadly I am nowhere near as experienced for what I am trying to achieve. I was hoping you experts could help. I've visualized my problem in Excel below to make it much easier to explain.

What I am trying to achieve in this example is to create a calculated column in my budget table (see yellow marked) that sums all of "price" (from another table) per projectnum, only if column "y/n" says "yes".

Is this doable in powerbi? If so, I hope someone can tell me!

Thanks as always!

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Resident Rockstar

## Re: Calculated column Sumif with multiple criteria from multiple tables.

Try this friend,

1.  create relationship between Budget and spent with name.

2. use the below dax to create cal column in budget table

Revenue= CALCULATE(SUM(Spent[price]),Budget[y/n]="Yes")

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

3 REPLIES 3
Highlighted
Resident Rockstar

## Re: Calculated column Sumif with multiple criteria from multiple tables.

Try this friend,

1.  create relationship between Budget and spent with name.

2. use the below dax to create cal column in budget table

Revenue= CALCULATE(SUM(Spent[price]),Budget[y/n]="Yes")

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

Highlighted
Super User IX

## Re: Calculated column Sumif with multiple criteria from multiple tables.

Create a project table

project = summarize(Budget,budget[Name],Budget[Y/N])

Join both the tables to this table using the project name. Now use the project [Y/N] as a slicer.

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution.
In case it does not help, please provide additional information and mark me with @

Thanks. My Recent Blogs -Decoding Direct Query - Time Intelligence, Winner Coloring on MAP, HR Analytics, Power BI Working with Non-Standard TimeAnd Comparing Data Across Date Ranges
Proud to be a Datanaut Connect on Linkedin

Proud to be a Super User!

Highlighted
Helper III

## Re: Calculated column Sumif with multiple criteria from multiple tables.

aaaah I am stupid. I didn't realize there was no relation between the tables, which is why my attempts didn't work

Works like a charm. Thanks 🙂

Announcements

#### Microsoft Ignite

This will be a conference that you do not want to miss!

#### Get Ready for Power BI Dev Camp

Don't miss the Power BI Dev Camp this week!

#### August Community Highlights

Check out a full recap of the month!

#### August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

#### Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Solution Authors
Top Kudoed Authors