Javier Guillen posted on March 04, 2011 09:20
Recently, I encountered a situation that required the use of SUMX as part of a DAX measure. Interestingly, SUMX seemed to only be taking in the integer part of the decimal used as part of the expression.
DAX expression # 1:
SUMX(FactResellerSales, FactResellerSales[SalesAmount] * 0.9 )
The result is 0 for all the cells on the pivot table.
DAX expression # 2:
SUMX(FactResellerSales, FactResellerSales[SalesAmount] * 2.9 )
The result reflects the fact that DAX only used 2 in the multiplication (instead of 2.9)
Hopefully this will be fixed in the next release.
As a workaround, you can create a DAX calculated column (instead of a measure), as the decimal is used properly there:
