Dax Ratio across fact tables
<p>I have two star schemas that share a few dimensions:</p>

<ol>
<li><p>Staff Star Schema.
This contains a fact table that has the grain of "staff role". so for every role a person held in the college there is a row, with a start and end date of that role.</p></li>
<li><p>Students Results Star Schema.
this schemas grain is a students results for a course on a yearly basis.One row per student per year with Pass or Fail.</p></li>
</ol>

<p>They share a date dimension. I can select a date and see aggregates for all staff employed at that point, and all students results for the year selected.</p>

<p>I now also need to be able to do a ratio of staff/students at that selected date. The problem is the staff is in one schema &amp; students in another, only sharing one dimension.</p>

<p>Is this even possible with dax or am i better to just do it in a stored procedure and reporting services?</p>