Sum of the values in a Matrix

[ErickReris]

Hello everyone, how are you?

I need your help. I have a Matrix in Power BI where, after adding a measure, it is not displaying the sum of the values for that hierarchy, as shown in the image below:

How can I make this measure show the sum of the values under the '3.1 Wi-Fi 5' hierarchy in the same row?

In summary, what I want is to display the sum of the values below '3.1 Wi-Fi 5' so that it groups them together:

[Anonymous · Accepted solution]

Hi @ErickReris ,

You can create a new measure as below and replace the original Values field with the new measure:

Measure =
SUMX (
    VALUES ( Table[Columns field1] ),
    SUMX ( VALUES ( Table[Columns field2] ), [Values field] )
)

In addition, you can refer the following links to try to solve your problem...

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 figure out, please provide some raw data in your tables(exclude sensitive data) with Text format and your expected result with backend logic and special examples. It would be helpful to find out the solution. You can refer the following link to share the required info:

How to provide sample data in the Power BI Forum

And 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

[audreygerred]

Hello! In formatting, make sure that Row subtotals is on and that you have the Position set to Top.

Then you should have results like this:

[ErickReris]

"Hello, I checked what you asked for and noticed that it is exactly as you mentioned, but it is still returning zero totals.

Do you have any other suggestions? Is it possible to create a measure that performs this calculation and groups by technology in the Matrix?"

To provide some context, I have a measure that calculates the total number of accessories in stock and multiplies it by the return percentage of each material. This shows, as an allocation, how much of that material is expected to return from the total number of accessories.

And this is the calculation being displayed in the Matrix.