Help with Formulas switching a table from 1-to-1 to 1-to-many

[pcuezze]

I have the table structure listed below and the two CALCULATED COLUMNS.  

The "Date of Service" calculated column is in the MWPAX table

The "Unique" calculalted column is in the MWTRN table.

I need to add non-unique values to the MWPAX table in the Payment Reference field.  When I do so, it breaks the formulas.  Further, it won't let me set cross-direction filter to "both" giving the following error which appears to be related to the Date of Service calculation.  I'm stuck and could really use some help!

[v-frfei-msft]

Hi @pcuezze ,

Firstly, you should to know what does the erro mean. You can refer to the third- party bolg to know about that. To avoid that, Please refer to this one.