DAX returning duplicates.

[Anonymous]

I have this DAX code, but it is retrieves a lot of duplicates values:

VAR finalEmpty=

CALCULATETABLE(

SELECTCOLUMNS(Planing,

"Hours", "empty",

"Assignment", "empty",

"Student", RELATED('Student current'[Name]),

"Student Number", related('Student current'[Student Number]),

"Date","empty",

),



not (Planing[DW_EK_Student]   in (Special2)),

Planing[DW_EK_Student]    in (empty2)





)

How could I do a  SELECTDISTINCT ??

Ps: special2 is

var Special =

FILTER(SUMMARIZE(Planing, Planing[DW_EK_Student],'Date'[Week Year Week Number])

, 'Date'[Week Year Week Number]=Nextw || 'Date'[Week Year Week Number]=NextNextw

)



var Special2=SUMMARIZE(Special, Planing[DW_EK_Student])

Empty2 is

var Empty1 =

FILTER(

    SUMMARIZE(

        'Student Current', 'Student Current'[DW_EK_Student],'Student Current'[Position],'Student Current'[Employment Status]),

'Student Current'[Position]<>"BT"   &&   'Student Current'[Employment Status] = "Active"

)

           







Var empty2 = SUMMARIZE(Empty1,'Student Current'[DW_EK_Student])

[Greg_Deckler]

@Anonymous You can use DISTINCT.