Forum Discussion
Recursive Measure with Parent-Child Relation
I know recursive measures have been discussed a few times in the Forum, but none of the solutions solve this issue: First of all we are operating in Direct Query Mode: We have a Ledger Table with E...
Make sure the empty parents are truly nulls, not empty strings. Then use a local data model and try to create a calculated column with a PATH statement. This may not work as generally calculated columns in a Direct Query scenario are limited to the same row. Can you add the PATH in your data source?