Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Vote for your favorite vizzies from the Power BI Dataviz World Championship submissions. Vote now!
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.
Vote for your favorite vizzies from the Power BI World Championship submissions!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
Check out the January 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 70 | |
| 51 | |
| 42 | |
| 29 | |
| 22 |
| User | Count |
|---|---|
| 142 | |
| 119 | |
| 56 | |
| 37 | |
| 32 |