Matrix Connections

[wlknsnBI]

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)

[mahoneypat]

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