Unexpected result in relationship between tables

[afbraga66]

Hi,

I have 2 tables that relate in the form below. F_PRODUCTION_ORDER (1) -> (*) F_PRODUCTION_DEFECT

The image below contains that only from table 1 - F_Production_Order. Notice how it has 3 Orden de Produccion.

Once I had a field from table 2 - F_Production_Defect, Orden 79440661867 disappears. This is because that record does not exist on table 2, which is normal.

If I set "Show Items with no data" it appears but with no value for Producido (m3) measure.

The expected result should have with the Producido (m3) value and in my opinion without the need to show items with no data.

How am I supposed to get that result?

I am getting wrong data due to this behaviour.

Link  to test example: https://we.tl/t-YtkMRwjXw8

Thank you,

Best regards,

André

[v-yanjiang-msft]

Hi @afbraga66 ,

By my test, if the Producido (m3) measure is composed of column in table 1 - F_Production_Order, it has no value in the begining, or if the Producido (m3) measure is composed of column in table 2 - F_Production_Defect, it has value whatever, I wander what the  Producido (m3) measure is defined, can you show me more details?

Best Regards,

Community Support Team_kalyj

[afbraga66]

Hello @v-yanjiang-msft 

I have re-added the file which has expired : https://we.tl/t-znEQzpVElh

The issue is that is feels like that when Power BI combines fields from two related tables it does an intersection/inner join of the data.

Thank you.

Best regards,

André

[amitchandak]

@afbraga66 , add + 0 to the measure Producido (m3)

example

Producido (m3) New  = [Producido (m3)] +0

or , if this is  column

Producido (m3) new = sum(Table[Producido (m3)]) +0

[afbraga66]

Hi @amitchandak 

I have tried that, but now not sure it works.

It now shows 0 values for all combinations I believe (makes no sense) and still hides the value for the Orden. The total is correct, but the individual value of the orden is nowhere to be seen.

Thank you.

Best regards,

André