Comparison matrix table

Hi 

Thank you for reaching out to Microsoft Fabric Community Forum

Below are the few points that will resolve your issue let us know if you need any further assistance.

• Your current Standard Cost = MAX(Standards[Standard Cost]) repeats the same value for each matching row, which may cause duplication or slight averaging in visuals.
• This happens when multiple rows in Actuals match the same Sub Assembly in Standards due to a many-to-one relationship.
• If the Standard Cost varies by Project Definition, update the LinkKey in both tables to include Project Definition.
• Update LinkKey in Actuals as: Actuals[Engine Spec] & "-" & Actuals[Sub Assembly] & "-" & Actuals[Project Definition]
• Update LinkKey in Standards as: Standards[Engine Spec] & "-" & Standards[Sub Assembly] & "-" & Standards[Project Definition]
• Recreate the relationship: Standards[LinkKey] (one) → Actuals[LinkKey] (many)
• If Standard Cost is fixed per Sub Assembly, use LOOKUPVALUE instead of a relationship

Please follow the below dax 

Standard Cost = LOOKUPVALUE(
Standards[Standard Cost],
Standards[Sub Assembly], Actuals[Sub Assembly],
Standards[Engine Spec], Actuals[Engine Spec]
)

If it is solved, please mark the helpful reply or share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.

Regards,

Chaithanya