Powerpivot distinctcount return wrong values

Dear All   I am new to powerpivot and trying to convert my excel file worksheet into powerpivot because my data is getting huge and hard to managed.   I need to calculate unique value in a colum...