cancel
Showing results for
Did you mean:

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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!

Announcements

#### Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

#### Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

#### Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors