Matrix and total for one column...

[Anonymous]

Hi All,

I have been googling for an answer to with a Matrix I want to just show one or two totals. I have turned off subtotal for rows and I read something about turning off group total but can not find it. Basically I want

id     name  deposit

1      mark    100

                        200

total             300

2       sue      200

                        1000

                        300

total             1500

I hope this makes sense.

[v-alq-msft · Accepted solution]

Hi, @Anonymous 

Based on my research, I created data to reproduce your scenario.

You may create a measure as  follows.

DepositValue = 
IF(
    ISFILTERED('Table'[Deposit]),
    BLANK(),
    SUM('Table'[Deposit])
)

Then you can make the matrix visual selected, go to 'Format' ribbon, click 'Row headers', uncheck 'Stepped layout', then click 'Subtotals', check 'Row subtotals' and 'Per row level', finally set Id and Name as Off and Deposit as On.

Finally you need to confirm that 'show data without item' is checked. Here is the result.

Best Regards

Allan

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

[amitchandak]

Please provide sample data, sample output you want.

In between refer to this :https://www.burningsuit.co.uk/blog/2019/04/7-secrets-of-the-matrix-visual/

[Anonymous]

Thanks for replying I supplied the example output the input would just be all the columns have the value repeated as shown.

[amitchandak]

Refer:https://community.powerbi.com/t5/Desktop/Display-data-in-matrix-Visual-like-tabular-format/td-p/4909...

[Greg_Deckler]

Sample source data would help. There is an option for row headers to turn off stepped layout, which may be what you are looing for. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[Anonymous]

In the options for the Matrix there is a section called "Subtotals".  Under that section is a toggle called "Per Row Level" and "Per Column Level".  Toggling either of these on will give you options to change which levels of your rows/columns will have totals.

These are a fairly new addition to Power BI, so make sure you have the latest version of Power BI Desktop

[Anonymous]

Hi Many Thanks!

I have the Febuary version of Power BI Desktop (not the app store veresion) for using for the cloud tenant and it only has Row subtotals which I have turned  off but no columnsubtotals under the subtotals.

Is the column subtotals somewhere else?