Showing results for 
Search instead for 
Did you mean: 
Not applicable

cardinality is filtering data/ data disappear when setting relationship

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


Community Support
Community Support

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.

Community Support
Community Support

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:



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.

Not applicable


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.





Helpful resources

September Update

Check it Out!

Click here to learn more about the September 2022 updates!

Power BI Show episode 9

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power BI Dev Camp Session 25

Ted's Dev Camp - August 25, 2022

Watch Session 25 of Ted's Dev Camp.

Top Solution Authors