Forum Discussion
Second Total in same Matrix
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
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.
3 Replies
Alex_G7 , two totals are not possible as of now. you can place the two, one behind the other and try
There are workarounds but they are pretty hacky.
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.
