Forum Discussion

iLikeAzureSQL's avatar
iLikeAzureSQL
Helper I
9 years ago
Solved

problem with reporting on multiple relationship

Hello everyone, I can't make multiple relantionship to work. Here is what I have:   Address Table - AddressID PK Person Table - PersonID PK PersonAddress Table - PersonAddressID PK - relation be...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi iLikeAzureSQL,

     

    I create a simple sample to test but it works on my side.  Below is the sample:

     

    Table:

     

    Relationship:

     

    Visual:

     

    Use relationship create a summary table.

     

    Formula:

    Table = SELECTCOLUMNS(PersonClass,"PersonclassID",[personclassID],"Person",RELATED(Person[Name]),"Class",RELATED(Class[ClaseName]),"Address",RELATED(Adress[Decription]))

     

     

    Regards,

    Xiaoxin Sheng