Excel Formuale / Dax expression for distinct counts with a conditional element

I need help with a specific problem.  I am extracting data from a dynamic spreadsheet which gets regular feeds for updates and additions in terms of rows.

I have 5 specific Columns –

1. Openings Remaining
2. Job Title
3. Location
4. Profile
5. Status

Each profile goes through six different stages ( which is the “ Status “ column.  .. Whenever a profile enters a new stage of operation a new row gets generated against the same profile .

We need the DAX expression / Excel formulae for the count number of job openings keeping in mind the fact that a profile may apply for more than one Job Title or for a different location as well

Please suggest a measure in DAX or Power query editor / Excel Formula to handle the above scenario.

Sample Data : 

https://docs.google.com/spreadsheets/d/1xXAVL-gfbR038LWsQG5F7c-Nmw-5Q5Zv/edit?usp=sharing&ouid=103433848391618212523&rtpof=true&sd=true