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

Anonymous's avatar
Anonymous
Not applicable
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

  • iLikeAzureSQL's avatar
    iLikeAzureSQL
    Helper I
    9 years ago

    Can you do this on dorect query reports?

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      Hi iLikeAzureSQL,

       

      I think it can't works on direct query mode. Perhaps you can try to do these work on database side.

       

      Regards,

      Xiaoxin Sheng