cancel
Showing results for
Did you mean:

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Regular Visitor

## Add Sumif values from a different table based on slicer selection

Hi,

I would like to fulfil a column with a sumif of values from a different table but with a filter from a slicer.

Let’s give the example:

• One table has a list of items with two columns (item number and Item description)

• Other table has the consumption of items (item number, quantity and consumption date

My objective is, keeping the first list with all items and add one more column to fulfil with the consumption for respective item.

But the consumption must change for the respective year selected on slicer with the year.

For example, if 2021 is selected on slicer, the item, in the first table the item "a" will appear with the value 2 on column consumption, all the other items will keep with no valeu or zero value.

If 2022 was selected on slicer, the item, in the first table the item "a" will appear with the valeu 4 on column consumption and item "c" with 14, all the other items will keep with no valeu or zero value.

Many Thanks

Nuno Paixão

1 ACCEPTED SOLUTION
Responsive Resident

Hi,

Right click the Item then tick show items with no data.

Please accept this as solution if this helped to solve your problem.

Thank you

4 REPLIES 4
Regular Visitor

Hi Dinesh,

many thanks, so simple.

KR

Nuno Paixão

Responsive Resident

First -  Create relationship between items table and consumption table base on Item.

Then create a mesure using  following DAX formula.

`Consumption = SUM(Consumptions[qtd])`

Then you will get the answer.

Please post back here if you are having issues.

If this post helped to solve your issue. Please acept as the solution.

Thank you.

Regular Visitor

Hi Dinesh,

Thanks, but I need keep the other items in the list with zero values.

Many Thanks

Nuno Paixão

Responsive Resident

Hi,

Right click the Item then tick show items with no data.

Please accept this as solution if this helped to solve your problem.

Thank you

Announcements

#### Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

#### Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

#### The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors