Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Reversing DAX statement

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)   ...
wdx223_Daniel's avatar
wdx223_Daniel
Community Champion
5 years ago

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)))