Sep 21 2023 02:05 AM
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 –
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 :
Sep 21 2023 04:51 AM
The measure could be
Job openings :=
COUNTROWS (
DISTINCT (
SELECTCOLUMNS (
data,
"P", data[Profile],
"L", data[Location],
"J", data[Job Title]
)
)
)