Relationship error when field placed in value but not label

This error is not caused by CLEAN/TRIM, nor by anything in the data values themselves.

It happens because of how Power Pivot resolves implicit measures and what table a value field “belongs to” in the star schema.

You did nothing wrong with your relationships.

The issue is structural:

Dimension tables cannot reliably produce implicit aggregation measures when grouped by fact-table fields.

Use explicit measures whenever a Products or Customers field must appear in Values.

This happens to everyone once—they try to sum a dimension field, and Power Pivot refuses with a relationship warning.

Define a measure in Orders:

Total Value : =SUMX(Orders,Orders[Order Quantity] * RELATED(Products[Unit Price]) + Orders[Shipping])

This is the proper star-schema fact aggregation.

No errors. Works with any slicers.

Hope this helps you, if not please just ignore it.

* It is better to give a bad answer than to give no answer at all. The user has to decide what is OK for them.