Forum Discussion
Solved
RELATED function does not work - is dual/import mode an issue or a "limited" relationship?
I have a simple measure I created as (below) that was working just fine when all of my data was from Excel files. The relationships between tables used to facilitate this measure are also included be...
frittzy see below from the documenation on RELATED() and limited relationships. It appears that your hunch that this is due to using a dual-mode/composite model is correct.
https://docs.microsoft.com/en-us/dax/related-function-dax
https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-relationships-understand#limited-relationships
frittzy see below from the documenation on RELATED() and limited relationships. It appears that your hunch that this is due to using a dual-mode/composite model is correct.
https://docs.microsoft.com/en-us/dax/related-function-dax
https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-relationships-understand#limited-relationships