Adding Total Row into Matrix visualization

[Anonymous]

Hello friends 🙂 ,

I have a request, but I don't know if it is feasible.

I have a Matrix visualization as shown below. There are some values ​​from tables that are linked.
There is also a Total row, where there are values ​​from the Total columns. I would like to add one more Total row, which would display summary values ​​from another table, specifically Sales. Otherwise, there would be 2 total lines below each other, with one remaining exactly as it is in the picture (that is, Total from the columns) and the second Total would be only one value for Sales for each column.
I can create summary metrics, but I don't know how to add one more Total row and if it is even possible.

Thanks for help

[Anonymous · Accepted solution]

Hi @Anonymous ,

One possible way is to create a field for the row of the matrix. Here I used Enter Data to create a table.

And make a relationship for tables.

Replace the new Category field with the original. You can see there's 'Total Sales' in it.

Measure = IF(SELECTEDVALUE('Table (2)'[Category])="Total Sales","SalesExpression",SUM('Table'[Value]))

Of course, this is only a temporary alternative, and other problems may arise.

Power BI doesn't have this kind of feature at the moment, and you can create a similar idea and vote on it.

Home (microsoft.com)

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.