bridge, many to many issue

[gidziu]

Going crazy with a bridge (many to many) issue. I have two tables: task (task_id, task_name) and user (user_id, user_name). Since each task can be assigned to one or many users and each user can own multiple tasks, I need bridge task_user with primary keys from each user and task tables.

task table:

user table:

user_task table (bridge):

PBI relationships:

First, PBI table visual based on just user table: 

Now, added task_name to the visual from task table:

The ask is this: I would like to display a list of users with a task name next to the user name. If no task is assigned to a user I would need empty string (user 3 record must be showing), if multiple tasks assigned to a user (e.g. user 1) just the the name of the first task should be shown. Something like this:

Possible? Appreciate any tips.

Thank you

[Ashish_Mathur]

Hi,

Change the relationships to single.  In the user_task table, write this calculated column formula

Task name = related(task[task name])

From the User table, drag the 2 columns to the visual.  Drag the Task name column from the user_task table.

[DvdH]

Power BI DAX Function FIRSTNONBLANK Example - Power BI Docs
I don't know the answer but i think this function could help for the only showing 1 task per user

[gidziu]

Thank you for input. I tried this option. Somehow many to many does not work well with FirstNonBlank