Ambiguous Relationships

Hi megm001,

I may misunderstand your requirement previously.:smileylol:

In your scenario, you can just remove the "Month Sort" table from your mode, then create bidirectional relationships among the other three tables like below.

And then you should be able to use the formula below to create a measure to get the Contact Date and show it with other three columns.

Measure for Contact Date = 
CALCULATE (
    MAX ( Table4[Contact Date] ),
    FILTER ( Table4, Table4[Month of Low Rating] = MAX ( Table1[MonthSurveyed] ) )
)

Note: replace Table1 and Table4 with your real table name, and format the measure to show only Month and Day under Modeling tab.

Here is sample pbix file for your reference. :smileyhappy:

Regards

Hi megm001,

Based on my test, the formula below should work to not show the "total" date. :smileyhappy:

Measure for Contact Date = 
IF (
    HASONEVALUE ( Table1[Company] ),
    CALCULATE (
        MAX ( Table4[Contact Date] ),
        FILTER ( Table4, Table4[Month of Low Rating] = MAX ( Table1[MonthSurveyed] ) )
    )
)

Regards