Forum Discussion
Anonymous
8 years agoNot applicable
Difference Between DAX and calculated column
Hello!
I’m' trying to figurate the difference between calculate the 'Total sales' in a column and in a measure because the output it's difference.
This is mi data:
So, the total sales it's ten. As you can see summing the 5 totals.
But. When I do the measure I don't have the same result. I notice that it's a common problem but i didn't figure how to solve it (Filter? Related? which function?)
So. This is my dax formula:
Thanks!
Hi Anonymous
This is where DAX iterators come in :)
Please try
Measure = SUMX('Data','Data'[Price] * 'Data'[Qty])
1 Reply
- Phil_SeamarkMicrosoft Employee
Hi Anonymous
This is where DAX iterators come in :)
Please try
Measure = SUMX('Data','Data'[Price] * 'Data'[Qty])