Forum Discussion

DKGH's avatar
DKGH
New Member
1 year ago
Solved

PBI doesn't recognize same text in a column

Hello everyone, First table is from my original dataset which I'm using look up value to create new column to another dataset. The problem is that when I do that, I end up having two exact text but ...
Need Help
  • v-achippa's avatar
    v-achippa
    1 year ago

    Hi DKGH,

     

    Thank you for reaching out to Microsoft Fabric Community.

     

    Since you are using calculated columns in power bi desktop so here is a DAX formula to normalize the text values:

    CleanSegment =

        SUBSTITUTE(

            SUBSTITUTE(

                TRIM([Summary Market Segment]),

                UNICHAR(160),

                ""

            ),

            UNICHAR(8203),

            ""

        )

     

    This removes the non breaking spaces and hidden characters that may have caused duplication like Other and ensures consistent matching across datasets.

     

    If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

     

    Thanks and regards,

    Anjan Kumar Chippa

d_rohlfs's avatar
d_rohlfs
Resolver II
1 year ago

Hi DKGH, 
I am not sure where this error is coming from, but it is likely happening for some purpose. But an easy solution for this is to go into your Power Query and simply do a replace values on the "Other" values so that any stray spaces, line breaks, tabs, etc. are removed. This may also help show the exact cell values as in a replaced values function the entire value is broken down into special characters (This will make more sense inside of the function). 
Thanks!

  • DKGH's avatar
    DKGH
    New Member
    1 year ago

    Hi d_rohlfs ,

    Thank you for your response, since I'm using create column in desktop I cannot use power query. I simply used data groups to collapse Other in same group, it's worked this way.