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 group sales to only return the 1,130,822 (which is the total based of the "Group" column. Is there a way to return just that? because i need the group sales value for another measure as well. 

Thanks!

 

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

5 Replies

  • 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!