Forum Discussion
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...
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
Can you do this on dorect query reports?
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