Forum Discussion

wlknsnBI's avatar
wlknsnBI
Helper II
5 years ago

Matrix Connections

Hi,

 

I have the following model. The goal is to be able to select any two dimensions as rows or columns and show the roles concatenated to the selected dimensions. Any ideas?

 

Example connection: "John Doe" (Contact) | "Microsoft" (Account) | "Employee" (Role)

Need Help

1 Reply

  • mahoneypat's avatar
    mahoneypat
    Microsoft Employee
    5 years ago

    This can be done with CONCATENATEX, but please say more about where you need to generate this string (calculated column, measure in a visual with ...)

    Regards,

    Pat