Referential Integrity Issue in Model (probably confusion)

[DataUsurper]

Hello All,

Am attemptingto identify the average order sale by main order ID, but the new-PBI-generated table ["keys.OrderDays"] isn't maintaining RI (I think) to the organic table [QROs].

I have a table of Quotes, Reservations and Orders [QROs] which has the line item details for orders. I created a new table ["keys.OrderDays"] in PBI to list one record per MainOrder ID (there are suborders w/ different IDs) and sum the total of the QROs's 'total' ('Total Line Total' field), then using this new-PBI-generated table ["keys.OrderDays"] I am calculating the average order (rather than the average of the records); however, it is not maintaining RI to the QRO table's "Main Location" field even though I do have it data-modeled to it.

Any suggestions on how I can correct this?

[v-frfei-msft · Accepted solution]

Hi @DataUsurper ,

How about changing the direction from single to both?