Forum Discussion
Problem using DIVIDE and TREATAS to calculate two columns from unrelated tables
Hi , I am trying to perform a simple divide cost per area for two columns from different tables that do not have a physical relationship. Well it can have a replationship but it would be a many to m...
Of course, it won't. But it's not DIVIDE that is at fault here. It's your understanding of DAX that's at fault.
SUMX is an iterator. You're iterating over ActivitiesAlt and only this table has a row context inside SUMX. You therefore cannot reference a row from a different table as no other table, apart from the iterated one, has a row context in there.
Best
Darek
SUMX is an iterator. You're iterating over ActivitiesAlt and only this table has a row context inside SUMX. You therefore cannot reference a row from a different table as no other table, apart from the iterated one, has a row context in there.
Best
Darek