Excel Power Pivot - Relationships BROKEN

[pbower]

Hi guys,

I am having a problem with Excel Power Pivot.

I have a many to one relationship between 2 tables, with the following formula:


=MAXX(RELATEDTABLE(REQUIRE),REQUIRE[UW_CLIENT_MEDICAL_TEST])

It is working correctly for most records, but for 1000 or the relationship is not working correctly and is returning blank cells!!!! I can even see the related number on both tables, and it should be passing a value across. It is not doing this!!!!!

I have confirmed that my (Many-to-One) "One" table only has one primary key value in each row.

This is doing my head in - what could I include in this board post to help make it a bit clearer?

Thanks

Peter