Manipulate filter context between tables

[fosterXO]

Hi,

I have an interactive report with two tables. The info selected in table 1 filters the info in table 2. However, I need table 2 to ONLY look into one of the columns of table one. I will filter out 2022 soon but I still need table 2 to add total correctly. Red cell should be 150, not 100.

How would you do it? Thanks

[Anonymous]

Hi @fosterXO ,

Please try:

Measure = CALCULATE(SUM('Table'[Column3]),ALLEXCEPT('Table','Table'[Column1]))

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data

[AllisonKennedy]

@fosterXO Sorry I'm not totally clear on what you want, but you can use the ALL function and put the column you're using as filter inside, eg:

NewMeasure = CALCULATE ( [currentmeasure], ALL( Tablename[columnusedinTable1Filter] ) )