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 is an error on the Lookupvalue function. The issue is that the lookupvalue function use active relations ship in order to calculate the result whereas we have to use this function when we don't want use relations.
When you don't have match values between 2 tables, the lookupvalue function will return blank values.
Here a little example :
Table Projects :
IdProject Project Name Manager ID
1 Project A 1
2 Project B 2
Table Users :
IdUser Name
1 Toto
2 Tata
Table Hours :
IdHour User ID Project ID
1 1 1
2 2 1
With this example, I have 2 relations :
Hours[User ID] To Users[IdUser]
Hours[Project ID] To Project[IdProject]
Then I need to get the Manager Name for Projects, let's do a calculated column :
Manager Name = LOOKUPVALUE ( Users[Name] ; Users[IdUser] ; Project[Manager ID] )
The manager name for the project B will display blank value because there is no any hour from Tata on this project.
If I delete a relation, no problem, but the goal is to get a value without the active relations.
I get an error when I try a lookupvalue or a related function into a calculate with relationsship context :
Manager Name = CALCULATE ( LOOKUPVALUE ( Users[Name] ; Users[IdUser] ; Project[Manager ID] ) ; USERELATIONSHIP ( Project [Manager ID] ; User[IdUser] )
Manager Name = CALCULATE ( RELATED ( User[Name] ) ; USERELATIONSHIP ( Project [Manager ID] ; User[IdUser] )
Thanks
I’m also not able to repro it in French Version : 2.41.4581.361 64-bit (November 2016) as below.
Best Regards,
Herbert
It seems to happen only in non english version of the freeware.
For tour information : I got a french version.
I’m a little confused about your problem, because I can always get the Manager name in Table Projects with your calculate column expression. Is there anything I missed here?
Best Regards,
Herbert
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 |
---|---|
114 | |
98 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |