Matrix Total Value Used for Another Field

[EvanGetsItDone]

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!

[mangaus1111]

yes REMOVEFILTERS is the same of ALL

[mangaus1111 · Accepted solution]

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]

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!

[EvanGetsItDone]

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

[EvanGetsItDone]

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()?