Dax expression for distinct counts with a conditional element

[indranil36]

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=10343...

[Ashish_Mathur · Accepted solution]

At the very least, show the expected result very clearly.

[lbendlin]

Your data is missing a timestamp column, and there are many more than six different stages.  Please revalidate.