Forum Discussion

coolasia's avatar
coolasia
New Member
8 years ago

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...
v-chuncz-msft's avatar
v-chuncz-msft
Community Support
8 years ago

coolasia,

 

Check if you've refreshed the data model.

  • coolasia's avatar
    coolasia
    New Member
    8 years ago

    Hi 

    Thanks for your reply..I have refresh but still same problem

    I suspect my problem with powerpivot is due to my data in the excel file.

    My excel file consist of data  with number and text. I notice that there is no

    problem for my data if it is TEXT, mixture of text & number or number that within 8 digit

    1.  BYTRUCK9010527936  (no problem)
    2. 25308407 (no problem)

    But when number become too long like below

    1. 43430660612014 , it will store the data in excel as “4.34307E+13”
    2. 43430660701011, it will store the data in excel as “”4.34307E+13”

    When Powerpivot extract the data, it will store it as “4.34307E+13” and count as 1 instead of 2.

     

    Any advise how to solve this kind of problem ?

     

    regards

    Ken

    • v-chuncz-msft's avatar
      v-chuncz-msft
      Community Support
      8 years ago

      coolasia,

       

      Try to check the steps in the Advanced Editor.