Forum Discussion
LookUp function (DAX) shows blanks when there are duplicates or same lookup value in other row
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?
1 Reply
- lbendlin
Super User
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-Forum/ba-p/963216
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/1447523
