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

Question

I need help with a specific problem.&nbsp; 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 –Openings RemainingJob TitleLocationProfileStatusEach profile goes through six different stages ( which is the “ Status “ column.&nbsp; .. 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&nbsp;Please suggest a measure in DAX or Power query editor / Excel Formula to handle the above scenario.&nbsp;Sample Data :&nbsp;https://docs.google.com/spreadsheets/d/1xXAVL-gfbR038LWsQG5F7c-Nmw-5Q5Zv/edit?usp=sharing&amp;ouid=10343...&nbsp;

sergeibaklan · Answer

indranil36&nbsp;
The measure could be
Job openings :=
COUNTROWS (
    DISTINCT (
        SELECTCOLUMNS (
            data,
            "P", data[Profile],
            "L", data[Location],
            "J", data[Job Title]
        )
    )
)

Forum Discussion

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

1 Reply

Resources