How to do it...

To complete this recipe, do the following:

1. Create the following measure:

Destinations = 
    VAR __Table1 = 'R06_Table'
    VAR __Table1a = 
        DISTINCT(
            SELECTCOLUMNS(
                __Table1,
                "__Destination",[Destination]
            )
        )
    VAR __Table2 = 
        FILTER(
            ALL('R06_Table'),
            'R06_Table'[Origin] IN __Table1a
        )
    VAR __Table2a = 
        DISTINCT(
            SELECTCOLUMNS(
                __Table2,
                "__Destination",[Destination])
            )
RETURN 
    CONCATENATEX(
        DISTINCT(
            UNION(__Table1a,__Table2a)
        ),
        [__Destination],
        ","
    )

2. On a Report page, create a Table visualization and place the Origin column into the Fields area of the visualization. Ensure that Origin is set to Don't summarize.
3. In the same Table visualization, place the Destinations measure into the Fields area.

The Destinations measure lists all values from the Destination column to which travel is possible from the Origin.