topic Reversing DAX statement in DAX Commands and Tips

Reversing DAX statement

Anonymous — Thu, 29 Oct 2020 11:47:09 GMT

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!

Re: Reversing DAX statement

Anonymous — Thu, 29 Oct 2020 14:37:10 GMT

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.

Re: Reversing DAX statement

wdx223_Daniel — Fri, 30 Oct 2020 04:25:21 GMT

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