I am using this expression to create a count of distinct students in a duplicated list. DISTINCTCOUNT('EMC College Grades'[Student_Number]) in my powerpivot model. How can I filter the resulting column in my pivot table or use it in a slicer?
Hi Cheryl,
The DISTINCTCOUNT function doesn't return a column, it returns a scalar (single value). I'm not sure how you'd want to use a distinct count in a Slicer. Can you provide an example?
Mynda
My list of duplicated student ids returns the number of distinct students with this funciton. I would like to report in my pivot table values where there are 10 or more distinct students. I have attached my file with a tab called distinct-count. The pivot table shows a column created with the function, and I want to filter for only values greater than 10 in that column.
Thanks for the sample file. Click the filter drop down in column A > Value filters > Greater than > 10.
Mynda
Thank you so much - I was looking to filter column B, and not looking for the value filter in that column. I appreciate your courses, they have been easy to understand, and such a great resource!
You're welcome, Cheryl. Glad you're enjoying the courses 🙂
