Count Distinct after dropping duplicates

[bkunwor]

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]

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.

[Anonymous]

Hi @bkunwor 

It is a DAX question posted in Power Query section...and we can't get clear picture without sample data...you can read the post and provide more info

How to Get Your Question Answered Quickly - Microsoft Power BI Community