Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Matrix and total for one column...

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 ...
Need Help
  • v-alq-msft's avatar
    v-alq-msft
    6 years ago

    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.

v-alq-msft's avatar
v-alq-msft
Community Support
6 years ago

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.