cardinality is filtering data/ data disappear when setting relationship

[Anonymous]

Hi All, 

I have 2 table. The main one contains location ID, Work Order ID (unique), Cost and the second one has Work order ID (multiple) and cost. 

I want to display the total cost per Location ID.

Beacuse I am a beginner I am displayin the second table so to check what is happening and if I do not create any replationship it shoes correctly all the Work Orders ID and if I add a relationship (Work Order ID from table 1 and 2 ) the new table displays only few of them. 

Can some explain why?

here an example

[v-yangliu-msft]

Hi  @Anonymous ,

In principle, the work order in Table 1 is unique. In Table 2, there are multiple work orders, and the relationship is one to many. The one-to-one is shown here.

can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

Best Regards,

Liu Yang

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

[v-yangliu-msft]

Hi  @simonboniz,

 1. You can check whether the work order column on the visual object is in the work order in the second table

2. The matrix will automatically calculate according to the default formula to see whether it is not the calculation formula you do not need

This is related to the relationship. I hope it can help you:

https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-create-and-manage-relationships

Best Regards,

Liu Yang

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

[Anonymous]

Hi, 

thanks for your reply.

When I display the total the data are only coming from PO Cost so why would it change.

Report 1 does not have all the Work orderds that PO Cost has.

Anyway I could understand if I can only see the Work Orders which are in both tables but I tested it and there is always some missing data which belong to both tables.

I hope this is clear.

Regards