Forum Discussion

greenda4's avatar
greenda4
New Member
20 days ago
Solved

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's avatar
    maruthisp
    20 days ago

    Hi 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

greenda4's avatar
greenda4
New Member
19 days ago

Yes, you are correct! I reviewed the relationships in the model view and was able to correct something. Thanks for your help!

v-abhinavmu's avatar
v-abhinavmu
Icon for Community Support rankCommunity Support
16 days ago

Hi greenda4​,

Thank you for the update. Glad to hear that reviewing the relationships in the model helped resolve the issue.

Thank you for sharing the confirmation with the community!