Forum Discussion

EvanGetsItDone's avatar
EvanGetsItDone
Icon for Helper I rankHelper 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
Icon for Solution Sage rankSolution 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
Icon for Helper I rankHelper 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()?