the filter is applied to all sheets, the result is the same. I have another value in Segment called "Segment_All". I had to implement some calculated members since I'm connected to olap cube. When Filter "Segment" is selected to "All" the worksheet "Top/Bottom Countries" should only show "Segment_All".
Would have to see your twbx workbook to give you a good answer -
Filtering and ranking (a table calculation) take place at different times in the order of operations
There are ways using Lookup(attr(dimension),0) in the filter shelf to force the table calculation to be processed out of order but that can not be passed from one sheet to another
Depending on how your book is set up it may or may not work for you
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.