Showing results for 
Search instead for 
Did you mean: 

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


Add if set by omitting filters

Hello, I explain the case:

In a data source is the table (InventoryCenter) where the inventories of the points of sale are, with the fields:

Cost center (which is the Point of Sale Code - there are several)

CodMol molecule code (it's like a Category Code there are several bar codes with the same CodMol)

The description of the material (of the molecule)

And point-of-sale inventory

... it has other fields, but those are the ones that seem essential to me for the example (there is also the Barcode, which like the Unique Code of the material, but is repeated by batch / expiration date).

In another data source (EDCEDI Inventory) is the distribution center inventory, with the fields:

CEDI (distribution center code - there are several CEDI)

CodMol molecule code (it is like a Category Code that is equal to the one in the table above)

The description of the material (of the molecule)

And the CEDI inventory

I also have a table (MasterMaterial) where the material master is (with the barcode and molecule code), if necessary to make the relationship.

So I'm making a table visual with the Columns Center (which is the point of sale), molecule code, description, inventory of the center and I want to attach the column inventory of the CEDI.

I would like to add if set of the CEDI inventory field by molecule code, without taking into account the point of sale column:


In the InvCEDI field, the sum of the inventory of that molecule must appear in the CEDI. Example in the 401 there are 43,175 of the code 1396, in the 801 40.330 ..., in the Column InvCEDI there can be 20.000 (when performing the sum), this number must appear the same in all the rows that have that molecule code:

I would like a suggestion with a DAX formula (NOT with intermediate tables where this CodMol and InvCEDI sum), to then be able to filter some CEDI of the sum.

I appreciate the suggestions.

Super User
Super User

Are you saying that the distribution center inventory is preallocated for each of the Centros ?

Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

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

Community News

Fabric Community News unified experience

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

Power BI Fabric Summit Carousel

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