Forum Discussion

snow87's avatar
snow87
Icon for Helper I rankHelper I
3 years ago

Duplicate only in report/service

Hi have a dataset where 14 rows have the value IF in the Clarity column. In the desktop app, in the power query interface or the dax interface these show up as the same value.

 

They even have the same value in a calculated column with:

Check =
COUNTROWS (
    FILTER (
        Certification_Data_Query,
        Certification_Data_Query[CERTIFIED_CLARITY] = EARLIER ( Certification_Data_Query[CERTIFIED_CLARITY] )
    )
)
 
so I don't think there's extra blankspace with any of them.
 
But when I look at the report in service (I only have it in service) I have 13 of one IF and one of another IF.
 
Any ideas?
Need Help

2 Replies

  • GilbertQ's avatar
    GilbertQ
    Icon for Super User rankSuper User
    3 years ago

    Hi snow87 

     

    In Power Query the data is case sensitive, so you have to make sure that the text has the exact upper and lower case spelling. If they are different it will be treated as different values.