Second Total in same Matrix

[Alex_G7]

I have Matrix 

see example bellow 

Matrix 1 show all the records 

Matrix 2 has filter to exclude "client" from calculation in just this visual

Client want to have single matrix 

with 2 totals (one after another or side by side)

where 

All records will be shown ,but second total with show results without "client"

Any idea how dispaly this info?

Thank you

[v-stephen-msft · Accepted solution]

Hi @Alex_G7 ,

You can create a measure like this

Measure = IF(HASONEVALUE('Table'[User]),BLANK(),CALCULATE(SUM('Table'[Values]),'Table'[User]<>"A"))

Then in the Field formatting, set the font color to white and apply it to header.

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.

[amitchandak]

@Alex_G7 , two totals are not possible as of now. you can place the two, one behind the other and try

[AlexisOlson]

There are workarounds but they are pretty hacky.