I am a beginner in DAX. I have a measure called "Actuals" and a table called "Accounts" with a column named "sign" - which is 1 for incoming cash flow and -1 for outgoing. Using these a new measure is defined as below:
Actuals with sign = SUMX("Accounts", [Actuals]*"Accounts[sign]")
From my understanding, this should iterate over rows of Accounts and multiply the value in sign column with the measure called "actuals". To me this seems equivalent to taking the sum of sign column and multiplying with "actuals" measure. But the result shows otherwise. Is my understanding incorrect ? how exactly is the calculation being done here ?
