How to show the total values of rows in a Matrix with number value having my columns values as percentage

Question

I've started to manage PowerBi from a couple of weeks so i'm a little bit confused about some things.

My problem is that i need a Matrix in my dashboard with percent values but i want the total in number value because the total of a percent of row shows me always 100% and i dont know about the number i'm working

This is my Matrix with percentage values

This is how i want the total of row returns me but with the columns values ins percentage

I've tried to make a measure counting the values

COUNT(OPSRespuestas[answer])

After that turn off the total of rows and add this measure to the values in my matrix but this is what i get

This is my table after trying add a measure with the total

It returns me the total for each of the columns and not the total of all my rows.

These are the tables i'm working with

This my top header values

This is my left header values

The answer column is what i need to count

This is my relationship between this 3 tables although i have many more intermediate table aside from this 3 as you're going to see in the next picture:

My relationship tables

So finally what i need is that this matrix shows me the total of answer in percentage for each of departments and group of questions and then show me total by department but with number value

Turn off "Total". Instead, write a DAX measure that calculates whatever you need for the total. Add the measure to the matrix. — RADO
I've just tried what you told me and i made i measure, i turned off the subtotal of rows and i added my measure to values in the Matrix but it returns me the Total for each of the columns — Noelia Sancho Mendez

Jelle Hoekstra Jelle Hoekstra · Accepted Answer · 2019-07-23T08:19:31

The problem you are experiencing has to do with context. Each row is seen as it own total population hence the 100% total. Each column in this row is evaluated against the total of that row to provide a percentage value.

In addition to adding a custom measure to replace the total, you could also consider computing a percentage against the grand total of all dimensions. This means that each cell gets evaluated against the the total of all rows and columns. In this ways the cell value would change compared to your first table but the row total does not evaluate to 100% anymore.

SUM ( [Value] ) / CALCULATE ( SUM ( [Value] ) ; ALL ( 'Your Table' ) )

How to show the total values of rows in a Matrix with number value having my columns values as percentage

1 Answers