Forum Discussion
Solved
Distinct Count Help
Hi, hoping someone can help, I think it is probably pretty simple, but with my lack of knowledge, I am just banging my head against a brick wall! I have a table, one column is an assessment ID, ther...
Can you clarify the desired result please? I don't think this is clear "I want to create a measure to count the number of rows with 1 in for distinct assessment IDs."
Do you want a distinct count of AssessmentID (with the table filtered for NC = 1)
or
do you want a count of NC = 1 rows for each AssessmentID?
or something else?
--
If you provide sample data and show the desired result you will get a better answer.
This is the desired outcome