Reversing DAX statement

[Anonymous]

Hi, can someone help?

I need this DAX calculation, but the other way around:
@ https://community.powerbi.com/t5/Quick-Measures-Gallery/Transitive-Closure/td-p/783828

(Output > DAX > Input)

Thanks for your help!

[wdx223_Daniel]

@Anonymous maybe this is what you want

here is the code

Input = VAR t=
SELECTCOLUMNS (
    GENERATE (
        GENERATE (
            ADDCOLUMNS (
                Output,
                "@path", SUBSTITUTE ( Output[Destinations], ";", "|" ),
                "@n",
                    LEN ( Output[Destinations] )
                        - LEN ( SUBSTITUTE ( Output[Destinations], ";", "" ) ) + 1
            ),
            GENERATESERIES ( 1, [@n], 1 )
        ),
        ROW ( "To", PATHITEM ( [@path], [Value] ) )
    ),
    "From", [From],
    "To", [To]
)
RETURN 
FILTER(t,VAR fr=[From] VAR tt=[To] RETURN COUNTROWS(FILTER(t,[From]=tt||[To]=fr)))

[Anonymous]

What does it mean "other way round"? There is no 1-1 correspondence from a relation to its transitive closure, so you can't really do what you require.