Forum Discussion
Manipulate filter context between tables
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
2 Replies
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] ) )
Hi fosterXO ,
Please try:Measure = CALCULATE(SUM('Table'[Column3]),ALLEXCEPT('Table','Table'[Column1]))Best Regards,
Gao
Community Support TeamIf 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
