Forum Discussion
Matrix Total row question
Hello everyone! I have a problem with the Total rows in a simple matrix I have. I have the single calculated column in a matrix, which is a Measure ( DIVIDE(something,something) ). The problem i...
Hi,
Let's say your current formula is DIVIDE(A, B). The Total row is summing up all of the A values and all of the B values separately and then dividing them.
To get the total the way you want, you need an iterator function (like SUMX). See here for a good explanation: http://exceleratorbi.com.au/sum-vs-sumx-in-dax/
Yes I guess a just quickly scanned your post - you need to provide the formula of your Measure!
I thought those were just numbers just looking at the picture that said Values...
Post the Measure formula and a sample of your data set up - not the Matrix output!
