Lookupvalue affected by relations (into non english version)

[Rémi]

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

[v-haibl-msft]

@Rémi

I’m also not able to repro it in French Version : 2.41.4581.361 64-bit (November 2016) as below.

Best Regards,

Herbert

[Rémi]

@v-haibl-msft

It seems to happen only in non english version of the freeware.

For tour information : I got a french version.

[v-haibl-msft]

@Rémi

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