Duplicate relationships and records

[Syndicate_Admin]

Good morning community, please need a help

I have the tables STOCK PRODUCTS, SUBGROUP, PRODUCTS. Where they have the following relationships:

1-STOCK PRODUCTS. Numeric Code (is the product id) related to PRODUCTS. CodigoNumerico

2-SUBGROUP. CodeGroup related to PRODUCTS. GroupCode

I also have a measure QUANTITY STOCK

Quantity Stock =

VWould Stock = SAt('Stock Products'[STOCKACTUAL])

RETURN

IF(ISBLONG(Stock), 0, Stock)

Then I put together a table with the PRODUCTS data. CodeNumber and the stock quantity measure

The problem arises when I incopo a descipcion of the table SUBGROUP where when incoporarla are repeated n number of times (by the amount of (DescriptionGroup) the data CodigoNumerico

Obviously there is something I am not interpreting about relationships.

I would appreciate your help please. Thank you!!!

[v-yiruan-msft]

Hi @jtur ,

Is the field [Cantidad Stock] on the below table visual a measure or the aggregation value of value field? If it is a measure, could you please provide the related formula? In order to find the cause of problem and give you a suitable solution, could you please provide some sample data in your tables "STOCK PRODUCTS" , "SUBGROUP" and "PRODUCTS" (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

How to upload PBI in Community

Best Regards

[Syndicate_Admin]

Good afternoon. Please need your help!!

Thank you

[v-yiruan-msft · Accepted solution]

Hi @Syndicate_Admin ，

Please update the formula of the measure [Cantidad Granel] and [Cantidad Stock] as below and check if they are what you want... You can find the details in the attachment.

Cantidad Granel = SUM('Illinois STOCK PRODUCTOS'[CANTIDADGRANEL])

Cantidad Stock =  SUM('Illinois STOCK PRODUCTOS'[STOCKACTUAL])

Best Regards

[Syndicate_Admin]

Send link to download the pbix file.

https://drive.google.com/drive/folders/1X9DMVTE82yfx6g6wkrWE4gCd8LCfRjfR?usp=sharing

Thanks a lot.

[mh2587]

enabling filtering direction to both then try 

[Syndicate_Admin]

Thanks for the prompt response but enable filtering address to both but continue the problem

 

[Syndicate_Admin]

Also try to have both realations with filter addressing as both but the problem continues