Row data not appearing, but totals are correct

[KEB]

Thank you for your help.

Included are the model and table visual, each are color coded to help explain my issue. 
Green = Rawlot (There will always be a record and contains the 1 side of all relationships (pfs_rawlotid)

Gold = Raw Production QA (Many records creation could occur before or after Sample QA (Red)
Red = Sample QA (Many records creation could occur before or after Raw Production QA (Gold)
In the pictured example my totals are accurate but not all of the row values are appearing. I expect 2,700 for the two values indicated and 932 for the last column. Arrows point to where I expect data to appear.

I do not have a record for Red data and expect those to be blank. 

I am using the show items with no data feature.
Can someone explain why my totals are accurate but the values that make up the total do not appear?
If I create a Red data record, for Germ and AA, the missing values appear.

Thank you for your time.

[PBInewbie9]

Hi KEB,

I have the same problem with my visual.

Have you been able to find a solution yet that you may want to share?

Thank you for your time.

[PaulDBrown]

@KEB 

What measure are you using?

[KEB]

@PaulDBrown I didn't create a measure. Example: I simply SUM Bushels in Bin column. The 8000 total is correct. 

[PaulDBrown]

@KEB 

Have you tried changing the relationships to "single" direction?

[KEB]

@PaulDBrown I did try the single direction relationship and the visual errors out.

[v-jingzhang]

Hi @KEB 

I can reproduce your scenario but I don't know why it works like this. My workaround is to remove the fields which are from the Red table (Sample QA) in the table visual as there is no data to display. Another workaround is to add all the id data into the Red table but leave other columns blank. By this way, I can remain the fields from Red table in the table visual and they display blank correctly.

My sample data: 

Result: 

Best Regards,

Community Support Team _ Jing Zhang

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