Forum Discussion

greenda4's avatar
greenda4
New Member
22 hours ago

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 ID: 77181316-2e02-44ea-b104-201ac8d72366

Also, I am getting an error on my visual saying "You are using fields that don't have a supported set of relationships". Not seeing the issue as I have used this LookUpValue function before.

1 Reply

  • maruthisp's avatar
    maruthisp
    Icon for Super User rankSuper User
    12 hours 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