Forum Discussion
indranil36
Sep 21, 2023Copper Contributor
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 – Openings Rema...
SergeiBaklan
Sep 21, 2023Diamond Contributor
The measure could be
Job openings :=
COUNTROWS (
DISTINCT (
SELECTCOLUMNS (
data,
"P", data[Profile],
"L", data[Location],
"J", data[Job Title]
)
)
)