LookUp function (DAX) shows blanks when there are duplicates or same lookup value in other row

[pepita0000]

Hello,

I have used the following dax measure:

it works fine when there are no duplicate values in the FACT table or when there are no repeated values used for the lookup (sk column)  in a different row as shown in the table

Why it does not show the same result from the first row in the last row when the lookup value (sk 1067) is the same?

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...