Create a calculated column/table for Openings Left

Hi, dreaves1 

Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.

Openings:

Hires:

There is no relationship between two tables. You may try creating a calculated column in 'Openings' table as below. The pbix file is attached in the end.

Result = 
[Total Openings]-
COUNTROWS(
    FILTER(
        Hires,
        [Company]=EARLIER(Openings[Company])&&
        [Company Name]=EARLIER(Openings[Company Name])&&
        [Discipline]=EARLIER(Openings[Discipline])&&
        [Recruiter]=EARLIER(Openings[Recruiter])&&
        [Req ID]=EARLIER(Openings[Req ID])&&
        [STEM/Business]=EARLIER(Openings[STEM Business])&&
        [Status]="Hired"
    )
)

Result:

Best Regards

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.