Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
hello there,
As shown below, I want to find whether the data in one column (contains many duplicated value) is exists in another table, I used the LOOKUPVALUE DAX as below, but only part of the cells in the new column that I created for checking returned the result. the rests are always blank. I'm struggling on this for days. Is anyone know this issue and can help me?
Thanks in advance.
Solved! Go to Solution.
I solved by myself, that I have an active relationship caused that problem.
I solved by myself, that I have an active relationship caused that problem.
Hello @Wayne_Wu888 ,
Just checking the Microsoft documentation here LOOKUPVALUE function (DAX) - DAX | Microsoft Learn:
When you read the alternate Result:
"When not provided, the function returns BLANK when result_columnName is filtered down to zero value or an error when more than one distinct value."
That should be your issue.
Hope it helps
@philouduv thanks, however in my screenshot, the search value is actually all same. what confuse me is only some of the cell can get the correct value from other table, but some can't
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
24 | |
20 | |
15 | |
12 |
User | Count |
---|---|
55 | |
48 | |
43 | |
19 | |
18 |