Forum Discussion

bonjourposte's avatar
bonjourposte
Helper V
2 years ago

RELATEDTABLE

Hi,

 

I have a table of loan numbers, and I need to return a list of tenants for each address (CODE), so I'm trying to retrieve data from the Many side and bring it into the One.  When I use RELATEDTABLE, the error message it gives me is "The expression refers to multiple columns.  Multiple columns cannot be converted to a scalar value."  But I WANT those mulitple lines, at least (not columns).  How do I write my DAX for this measure?

 

This is the measure I've written:

 

NumberofTenants = FILTER(RELATEDTABLE(LEASMAST),LEASMAST[TENANT_NAME])
 
The One side where I've written this measure is LOANCOLL.  The Many side is LEASMAST.
 
How do I get that list?
Need Help

2 Replies

  • elitesmitpatel's avatar
    elitesmitpatel
    Solution Supplier
    2 years ago

    Try this 
    1) TenantsList =
    CONCATENATEX(
    RELATEDTABLE(Tenants),
    Tenants[TenantName],
    ", "
    )

    2) if above one fails try this 

    TenantsPerAddress =
    VAR Tenants =
    SUMMARIZECOLUMNS(
    'TenantTable',
    "Tenant", [TenantName] -- Replace with actual tenant name column
    )
    RETURN
    CONCATENATX(
    Tenants,
    Tenants[Tenant],
    ", " -- Adjust delimiter as needed
    )

     

    If it helps you please Aceept it as Solution so others can get the solution of this problem

    Thank you

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    2 years ago

    Hi,

    Share some data to work with and show the expected result.  Share data in a format that can be pasted in an MS Excel file.