Forum Discussion
Helper IVLookup does not return value for all exact similar rows
Hi amirghaderi ,
Try this. Please create a new calculated column.
Booking Code Description = MAXX ( FILTER ( 't_BB', 't_A'[Booking Code] = 't_BB'[EA / Jobcard] ), 't_BB'[Description] )I look forward to hearing from you.
Community Support Team_GaoIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data
Hi amirghaderi ,
Try this. Please create a new calculated column.
Booking Code Description =
MAXX (
FILTER ( 't_BB', 't_A'[Booking Code] = 't_BB'[EA / Jobcard] ),
't_BB'[Description]
)
I look forward to hearing from you.
Community Support Team_Gao
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data
I had this same issue. The fix to keep the same Lookupvalue formula is to look at the data model relationships between the 2 tables. Sometimes, if there are ambiguous relationships or multiple relationships, it can cause unexpected behavior in DAX calculations.
After deleting one of the relationships the lookupformula worked pulling all the values correctly.