Forum Discussion

bkunwor's avatar
bkunwor
New Member
4 years ago

Count Distinct after dropping duplicates

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 ? 

 

 

Need Help
Tips and Tricks

2 Replies

  • v-yingjl's avatar
    v-yingjl
    Community Support
    4 years ago

    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.