Power BI - Matrix visual sum total in row

[BFERRAZ]

Hello everyone, this is my first post on a forum so please pardon me if there are any mistakes.

I have constructed the following matrix in Power BI, I would like to know now if is there a way I can also make a sum in column "VOLUME" - the problem is that it is located at "Rows" and it doesn't allow me to sum them.

Basically the following but with the VOLUME Total showing here.

[v-sdhruv]

Hi @BFERRAZ ,
Just wanted to check if you had the opportunity to review the suggestion provided by the Super User?
If his response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.

[v-sdhruv]

Hi @BFERRAZ ,
Just wanted to check if you had the opportunity to review the suggestion provided by the Super User?
If his response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.

[v-sdhruv]

Hi @BFERRAZ ,
Just wanted to check if you had the opportunity to review the suggestion provided by the Super User?
If his response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.

[danextian · Accepted solution]

Hi @BFERRAZ 

Think of a matrices in Power BI as pivot tables in Excel. That you can't do in Excel and in Power BI  out of the box The workaround is to use a disconnected table that holds the desired column names with hierarchies if needed and a measure referencing the columns in that disconnected table. You will also need to apply dynamic format strings.

Please see the attached sample pbix.

[BFERRAZ]

Sorry for the late reply but it works perfectly.

You are definetly a life saver. This solution was fire.

[lbendlin]

That's an Excel thing.  You don't do stuff like this in Power BI.