Forum Discussion
Solved
Lookupvalue
Hello, Hi, I am fairly new to Power BI and have a problem I cannot solve, I'm facing a problem when trying to find the vehicle data using the following table information. I need a measure that ...
Hi ekor-sembilan ,
I created a sample pbix file(see the attachment), please check if that is what you want. You can create a calculated column as below in 'Table 1' to get it:
Vehicle = CALCULATE ( MAX ( 'Table 2'[Vechicle] ), FILTER ( 'Table 2', 'Table 2'[VehicleID] = 'Table 1'[VehicleID] ) )Or you can create a measure as below to get it:
Measure = VAR _selvid = SELECTEDVALUE ( 'Table 1'[VehicleID] ) RETURN CALCULATE ( MAX ( 'Table 2'[Vechicle] ), FILTER ( 'Table 2', 'Table 2'[VehicleID] = _selvid ) )Best Regards
ekor-sembilan OK, so you can't use a measure if you want it as a calculated column in a table. Here is the calculated column form:
Column in Table 3=
VAR __UserID = [UserId]
VAR __VehicalID = MAXX(FILTER('Table 1', [UserID] = __UserID), [Vehicle])
VAR __Vehical = MAXX(FILTER('Table 2', [VehicalID] = __VehicalID), [Vehical])
RETURN
__VehicalThis assumes no relationships. If you have relationships you can probably use RELATED.
Hello Greg,
Thanks for your quick reply.
But, it's strange that the value is not the same. Here is the capture
Thanks