The goal is to be able to select any 2 dimensions (accounts, contacts, contracts & users), and show a concatenation of the roles for that connection in a matrix. As you can see from the model, the connections can be linked to any type of record but they always have a role.
Hi @Wlknsn, we aim to consistently improve the topics being posted on the forum to help you in getting a strong solution faster. While waiting for a response, here are some tips so you can get the most out of the forum and other Enterprise DNA resources.
Use the forum search to discover if your query has been asked before by another member.
When posting a topic with formula make sure that it is correctly formatted to preformatted text </>.
Use the proper category that best describes your topic
Provide as much context to a question as possible.
Include the masked demo pbix file, images of the entire scenario you are dealing with, screenshot of the data model, details of how you want to visualize a result, and any other supporting links and details.
Looks like an interesting problem. One of the things that would be helpful is better understanding where you’re running into problems with your solution. Is it a) calculation of the roles, given the dimension selections or b) displaying the selected concatenations in the matrix?
If the latter, I think the CONCATENATEX/UNICHAR( 10 ) combo may solve your problem. This is one of my favorite tricks, since while it technically returns a scalar, the result looks like it’s returning a table. Here are some prior solutions I’ve posted using this approach:
If the former, I be glad to work on this, but it’s more than I can do in my head as a thought experiment, and will need an anonymized PBIX file and a clear mockup of the end result you are trying to achieve.
A response on this post has been tagged as “Solution”. If you have a follow question or concern related to this topic, please remove the Solution tag first by clicking the three dots beside Reply and then untick the check box. Thanks!