cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

## 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 is that the sum of all these values is NOT the Total shown below the values. Say, 25,6+5,3+3,4+3,3+2,2+1,4 = 41,2, NOT 39,2.

Any advise to make the Total row work properly, or to udnerstand what's going on?

3 REPLIES 3
Resolver III

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/

Community Champion

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!

Community Champion

@aszpicCheck the Data Type, Default Summarization, etc... - that I've highlighted in the picture

Hopefully one of these things will resolve this!

Good Luck!