Forum Discussion

Alex_G7's avatar
Alex_G7
Icon for Helper I rankHelper I
5 years ago
Solved

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 (o...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    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.

     

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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.