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.

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

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