topic Re: Subtotals showing up 0 in matrix, even though there are values to sum up in them. in Developer

Subtotals showing up 0 in matrix, even though there are values to sum up in them.

Alahianambi — Thu, 05 May 2022 13:19:07 GMT

We have a matrix with two dimensions ( Level A and Level B) and an associated measure (Revenue). When we put all these together, i.e. Revenue in Values and Level A, Level B in Rows(As Hierarchy - Level A is higher level and Level B is lower level) . We are getting values as 0 in Level A (eventhough we have values in Level B to sum up and show).

We tried multiple options and there is a limitation that we can't use DAX. Anyone has faced such an issue?

Re: Subtotals showing up 0 in matrix, even though there are values to sum up in them.

Anonymous — Mon, 09 May 2022 08:31:20 GMT

Hi @ekoland ,

You can create another new measure as below base on the measure [Revenue] to get the correct total value and put this new measure to replace the original measure [Revenue] onto the matrix:

Measure = SUMX ( GROUPBY ( 'Table', 'Table'[Level A], 'Table'[Level B] ), [Revenue] )

In addition, you can refer the method in the following links to resolve it.

Why Your Total Is Incorrect In Power BI - The Key DAX Concept To Understand

Dax for Power BI: Fixing Incorrect Measure Totals

If the above one can't help you get the desired result, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

How to upload PBI in Community

Best Regards

Re: Subtotals showing up 0 in matrix, even though there are values to sum up in them.

Alahianambi — Wed, 11 May 2022 17:14:32 GMT

Below is how my matrix looks like. XA1, XA2 and so on are the LEVEL 1 hierarchies. A,B,C and so on are the LEVEL 2 hierarchies. Eventhough there are values in LEVEL 2, they don't sum up properly and display in totals in LEVEL 1. They either display 0 or the lowest value among LEVEL 2 values. Please let me know if you have further queries.

Column1Column2

XA1	0
A	23
B	25
B1	0
XA2	3
C	45
D	3
XA3	0
E	45
F	0
XA4	98
G	3434
H	98

Re: Subtotals showing up 0 in matrix, even though there are values to sum up in them.

Anonymous — Thu, 12 May 2022 08:27:11 GMT

Hi @Alahianambi ,

If the matrix displays the values correctly at different levels with only the data you have provided available. Not sure if your matrix has any measure or other settings applied...

Column1Column2

XA1	0
A	23
B	25
B1	0
XA2	3
C	45
D	3
XA3	0
E	45
F	0
XA4	98
G	3434
H	98

In order to give you a suitable solution quickly, could you please share some raw data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. Please provide the related formula if the matrix apply any measure... It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

How to upload PBI in Community

Best Regards