Duplicate only in report/service

[snow87]

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?

[GilbertQ]

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.

[snow87]

They're all all caps