title: why a single-only existing relation between fact-table & dim-table is inactive --AdventureWorksDW
body: <p>I have a situation -- I noticed that the only exisiting-single relation between the (Fact-table) FactResellerSales and DimReseller (dimension table) is inactive. I happen to notice it as I am unable to filter FactResellerSales -- total-sales by a Reseller-column in DimResller-table -- as I get the same total across all the Resellers in the row.</p>
  <p>My concern is, what could the scenarios a relation could be inactive other than when there are multiple-relations between a given fact-table and dimension-table?</p>
  <p>Would anyone please help me understand the scenario? Please find the screenshot of the model. Thank you for giving your valuable time.</p>
  <p><a href="https://i.stack.imgur.com/0JxLN.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/0JxLN.png" alt="enter image description here" /></a></p>