title: filter matrix based on another table in power bi
body: <p>I am trying to display in a matrix only rows that are assigned by different tables. Below are examples of my tables. </p>
  
  <p><a href="https://i.stack.imgur.com/teH6p.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/teH6p.png" alt="measures fact table"></a></p>
  
  <p><a href="https://i.stack.imgur.com/9F51o.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/9F51o.png" alt="measures specialty dim"></a></p>
  
  <p><a href="https://i.stack.imgur.com/Y3s2I.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Y3s2I.png" alt="category dim"></a></p>
  
  <p>I want an output similar to the image below <a href="https://i.stack.imgur.com/V3VTp.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/V3VTp.png" alt="mock up"></a> but I need a graph for each measure. At this time I think that I need to create an individual graph for each measure and update them independently (that may be a separate issue). I want to only display the measures that are assigned to the individual that I select. </p>
  
  <p>The fact table has thousands of rows with hundreds of people. I am looking to produce a dashboard that displays the rates for one person's assigned measures based on the measures assigned to them from their specialties. I've done many searches and haven't found a similar enough question and tried using the RELATEDTABLE function without success.</p>
  
  <p>Here are my relationships I've created:</p>
  
  <p><a href="https://i.stack.imgur.com/iEBfk.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/iEBfk.png" alt="relationships"></a></p>
  
  <p>The only way I was able to get the display to work properly was to create an additional table that lists the measures as rows, each specialty is a column and is binary (see below). </p>
  
  <p><a href="https://i.stack.imgur.com/0wZqf.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/0wZqf.png" alt="binary table"></a></p>
  
  <p>I currently have to select the specialty within this table (binary specialty) as a filter then filter for the value "1" to get the display correct, showing only assigned measures. This is not effective; I am looking to be able to select the person and have the measures assigned to them automatically display. I'm relatively new to DAX and I feel like there must be a way. </p>