Forum Discussion
Using LookUpValue
Hi, I created a calculated column and trying to use the LookUpValue function and am receiving the following error Underlying Error: DataViewMappingError_ConditionNotHierarchicallyRelated Activity ...
maruthisp
Super User
Super UserHi greenda4,
The error looks more related to the data model/relationships used by the visual.
LOOKUPVALUE can return a value from another table even when there is no physical relationship, but that does not create a relationship between the two tables. If you then place fields from both unrelated tables in the same visual, Power BI can return this message "You are using fields that don't have a supported set of relationships"
Please check the relationships in the data model.
Best Regards,
Maruthi
LinkedIn - http://www.linkedin.com/in/maruthi-siva-prasad/
X - Maruthi Siva Prasad - (@MaruthiSP) / X
Yes, you are correct! I reviewed the relationships in the model view and was able to correct something. Thanks for your help!
