Count Distinct after dropping duplicates

bkunwor · ‎10-27-2021

Scenario: A student_one can enroll in fall as full-time student and enroll in spring as part-time but when you report the total enrollment, he/she should be counted only once. A student_2 can enroll as full-time for both semesters. He/she should be dropped for the spring semester for counting. I can simply use the distinct count DAX function to achieve this goal.

Student_one enrolls in fall as full-time and enrolls in spring as part-time. He/she will be reported only as full-time for fall semester even though he/she enrolls as a part-time in the spring semester. Distinctcount dax function does not help anymore.

Any idea how to fix this problem without actually dropping student duplicates by ID ?

v-yingjl · ‎10-31-2021

Hi @bkunwor ,

Based on the description, not certain how did you define the full-time/part-time student in spring/fall and what did the table look like.

Perhaps you can consider sharing a sample data table or more details about this thread for further. Sample data and expected output would help tremendously.

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.