If I understand your question when you link the tables together (using the active link) then total number of marks in the viz changes - - that is the expected action -
No the second part is that the change does not meet you expectation - Can't be specific without looking at the data but the number of marks will be dependent on the Filtered view in the viz after you connect or disconnect the link - the filters will still apply
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.