cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
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

Cardinality.png

3 REPLIES 3
v-yangliu-msft
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.

v-yangliu-msft
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

v-yangliu-msft_0-1607648318820.png

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

 

v-yangliu-msft_1-1607648318823.png

 

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
Not applicable

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

 

 

Helpful resources

Announcements
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