Get values in the rows of a table

[BIA1996]

Hi Power Bi Users,

I have the following issue.

I have a risk table which contains a risk ID colum, and an action table which contains an action ID column. 

For one risk, there is one or more action, and there's a bridge table containing all the action names each one with their own risk. This table is linked to the other two tables with action ID and risk ID columns.

I have to create a DAX measue that, if I select a risk ID on a slicer menu, lists in the rows of a table each action name.

Which are the steps? How can I do it?

Thank you so much 

[BIA1996]

I have tried with CONCATENATEX but it gives me all the values on a single row, separated by a comma. This is not the correct solution

[Anonymous · Accepted solution]

Hi  @BIA1996 ,

If you want the slicer to display the [action name] of the selected value in each row when the slicer selects a value of [risk ID], you can place the [risk ID] and [action names] directly in the table viusal because the two tables are connected by a bridged table, and when the filtering direction is correct, you can display the correct value directly.

If you want to display the spliced [action names] grouped by [disk ID], you can use the following measure:

Measure =
CONCATENATEX(
    FILTER(ALL('bridge table'),[risk ID]=MAX('bridge table'[risk ID])),[action names],"-")

If the above results do not meet your expected results, you can express the expected results in the form of a picture, we can better help you!

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly