Problem with relations

[Anonymous]

Hello everyone.

I have this data model:

I have (or at least I tried) to have a bridge table with only the conversation ID field (and all the measures) to improve the relatinship between tables. This is working, but only with information of two of them. If I put a table with the conversation ID, a field from a second table and a field from a third one, it breaks. I already tried to change the relationships to both ways, but I always have the same issue. It is for sure a bad design, can anyone help me?

I have another question. One field related to the ID has several values separated in files, so each time I add the conversation ID and that field (tags). If the ID has 4 tags, I have 4 files with the same ID. That's the expected behaviour, but I need to put these tags in a line. I tried a conctatenatex measure, but it puts me all the tags instead of the ones related to the conversation. I could achieve it on Qlik with an aggr(concat(distinct measure, but I don't know how to do it in Power BI

[Anonymous]

Just to update:

I solved the first question. I was using as bridge a table created from another with DAX. Instead of that, I did it in the Power Query and marked it as Reference. That fixed the issue.

Regarding the second question (concatenate several results from several rows in the same column), I am getting closer with the CONCATENATEX function, but I am having issues with blank records.

[Anonymous · Accepted solution]

Hi @Anonymous ,

Please create a measure as below and check if it will return your expected result...

Measure =
CONCATENATEX (
    FILTER (
        ALLSELECTED ( 'Table' ),
        'Table'[ID] = SELECTEDVALUE ( 'Table'[ID] )
            && 'Table'[Tags] <> BLANK ()
    ),
    'Table'[Tags],
    ";",
    'Table'[Tags], ASC
)

If the above ones can't help you, could you please provide some raw data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples? It would be helpful to find out the solution. You can refer the following links to share the required info:

How to provide sample data in the Power BI Forum

How to Get Your Question Answered Quickly

And It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

How to upload PBI in Community

Best Regards