lookupvalue pathitem hierarchy error

[mthass]

Hi!

Trying to build a hierarchy in ssas tabular using dax function:

=LOOKUPVALUE(DimCompanyStructure[cDescriptionID], DimCompanyStructure[SysGen_DimOrganizationUnit_Key], PATHITEM([Path], 1, 1))

I have the Path and depth, but when trying to lookup the "parent" value, the following error occurs:

-->The syntax for '1' is incorrect. (DAX(
LOOKUPVALUE(DimCompanyStructure[cDescriptionID], DimCompanyStructure[SysGen_DimOrganizationUnit_Key], PATHITEM([Path], 1. 1))
)).

When i change to this:

=LOOKUPVALUE(DimCompanyStructure[cDescriptionID], DimCompanyStructure[SysGen_DimOrganizationUnit_Key], PATHITEM([Path], 1, ))

The following error occurs:

Function 'LOOKUPVALUE' does not support comparing values of type Integer with values of type Text. Consider using 

I found some examples on the forum for this purpose and did exactly the same?

[v-yulgu-msft · Accepted solution]

Hi @mthass,

As your problem is more related to SSAS, please post thread on SSAS forum to get more professional advice.

Regards,

Yuliana Gu