Measure Issue in visual table

Hi Saxon202202 

Welcome to the Microsoft Fabric Forum,

Also thank you all for responding on this topic.
 

Regarding the measure to compare Stock and Qty values, the issue arises due to the many-to-one relationship between the Data and Report tables. When you pull non-aggregated fields (such as Qty) from the Data table, Power BI attempts to display all matching combinations based on the relationship.
 

In your case, the Item "123-01" in the Report table has two entries, while the Data table may contain multiple corresponding Qty values for the same item. As a result, Power BI cross-joins each matching Qty with the related Report rows, leading to duplicate lines in the visual.

In Power BI, row duplication occurs when non-aggregated columns are pulled from the "one" side of a many-to-one relationship, where the "one" side contains multiple matching rows.

To evaluate each record in the Report table individually without aggregation and to avoid duplicate lines, you should create a calculated column in the Report table.

Try using  the LOOKUPVALUE function as follows:

Comparison =

VAR DataQty = LOOKUPVALUE(Data[Qty], Data[Item], Report[Item])

RETURN

    IF(Report[Stock] >= DataQty, "Yes", "No")

If this information helps resolve your issue, kindly consider marking this response as the Accepted Solution, as it may assist other community members facing similar challenges.

Thank you for being part of the Microsoft Fabric Community.