Forum Discussion

EvanGetsItDone's avatar
EvanGetsItDone
Helper I
3 years ago
Solved

Matrix Total Value Used for Another Field

Is there any way to achieve this? Basically, for the "group sales" column, I only need to display or return the value of the Total based of the column "Group" so for this scenario, I need the ...
Need Help
  • mangaus1111's avatar
    mangaus1111
    3 years ago

    Hi EvanGetsItDone ,

    you can try

    CALCULATE(

                SUMX('Table'[sales]),

              REMOVEFILTERS('Table'[Site]),REMOVEFILTERS('Table'[Customer])

)

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

mangaus1111's avatar
mangaus1111
Solution Sage
3 years ago

Hi EvanGetsItDone ,

you can try

CALCULATE(

                SUMX('Table'[sales]),

              REMOVEFILTERS('Table'[Site]),REMOVEFILTERS('Table'[Customer])

)

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

  • EvanGetsItDone's avatar
    EvanGetsItDone
    Helper I
    3 years ago

    Hey thanks, I think I got the context you provided, The REMOVEFILTERS() function is greyed out for me or disabled, not sure maybe from the way I am pulling my data, are there any alternatives for the removefilters()?

     



  • EvanGetsItDone's avatar
    EvanGetsItDone
    Helper I
    3 years ago

    Hello, I used ALL() instead of remove filters and it worked. Thanks for bringing out the idea and concept. 

  • EvanGetsItDone's avatar
    EvanGetsItDone
    Helper I
    3 years ago

    since ALL() is gonna show on every row. Is there any way to just show the value on the top of level of the matrix? thanks!