title: Tableau- Filtering based on another element
body: <p>I have multiple tables with one common element (ID). The first table has is the only one that has the ID and First Name. In a dashboard, I am trying to create a filter where when I type in or select the First Name, all data from all tables relating to the First Name's ID would populate. </p>
  
  <p>FYI, I don't want to join the data. My actual tables are big data from multiple sources I would like to find an alternative route to this. </p>
  
  <p>I also tried to create a parameter for the First Name and then created a Calculated Field with </p>
  
  <pre><code>IF [Parameter]=[Name] 
  THEN [ID] 
  ELSE NULL 
  END
  </code></pre>
  
  <p>but this didn't work. I am very new to Tableau and I'm thinking that there must be a way where the choosing a Name would trigger the ID and its relevant data.</p>