Forum Discussion

mthass's avatar
mthass
Regular Visitor
8 years ago
Solved

lookupvalue pathitem hierarchy error

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?

1 Reply

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee

    Hi mthass,

     

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

     

    Regards,

    Yuliana Gu