RELATEDTABLE

[bonjourposte]

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?

[Ashish_Mathur]

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.

[elitesmitpatel]

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