Excel Formuale / 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...

[#2]

@indranil36 

The measure could be

Job openings :=
COUNTROWS (
    DISTINCT (
        SELECTCOLUMNS (
            data,
            "P", data[Profile],
            "L", data[Location],
            "J", data[Job Title]
        )
    )
)