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,
I have a problem in lookup, it gets me missing datas in local function.
I can't define if the issue is in my data model or in my function.
Function :
Thanks
Solved! Go to Solution.
@AyoubDE Try using MAXX(FILTER(...),...) instead of LOOKUPVALUE. I have had weird results with LOOKUPVALUE due to things like DAX being case insensitive. Thus, "Category" and "category" are the same thing to DAX and this can cause LOOKUPVALUE to fail because more than one row is returned. MAXX(FILTER(...),...) has no such issue.
@AyoubDE Try using MAXX(FILTER(...),...) instead of LOOKUPVALUE. I have had weird results with LOOKUPVALUE due to things like DAX being case insensitive. Thus, "Category" and "category" are the same thing to DAX and this can cause LOOKUPVALUE to fail because more than one row is returned. MAXX(FILTER(...),...) has no such issue.
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 |
---|---|
107 | |
97 | |
75 | |
63 | |
53 |
User | Count |
---|---|
139 | |
100 | |
95 | |
85 | |
63 |