Forum Discussion
Issue with SUMX function
Hello!
I see that you are adding the data using FactInternetSales as context, which means that it will go row by row in that table doing the operation you indicated, to see that result modifies the type of summarization that the columns of ImporteVentas and ExtendedAmount have
Hello, it is the same as I explain, everything depends on the filter context, when you remove the Sales order number everything is damaged because you removed the context from the matrix and therefore it is adding the data, basically it is adding all the 2.9 and it is adding them. This happens because you are directly using the columns with the measurements without a correct filter context.
If this post is helpful in helping you solve your problem, consider giving the post a thumbs up
and accept it as a solution!
Hello, it is the same as I explain, everything depends on the filter context, when you remove the Sales order number everything is damaged because you removed the context from the matrix and therefore it is adding the data, basically it is adding all the 2.9 and it is adding them. This happens because you are directly using the columns with the measurements without a correct filter context.
If this post is helpful in helping you solve your problem, consider giving the post a thumbs up
and accept it as a solution!
Calculated correctly after adding salesordernumber column to the table. Thank you