identify the cases that has the same id but different name

[mina97]

hey i want to identify the cases that has the same id but different name 

T if the Id has multible names F if id has only unique name 

thank you 

i have the following data 

id	name
216000300	jack
216000300	noah
217000301	jousef

[Dangar332 · Accepted solution]

hi, @mina97 

try below code 

result =

var a =CALCULATE(DISTINCTCOUNT('Table'[name]),ALL('Table'[name]))

return

IF(a>1,"F","T")

adjust your table name

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly. Appreciate your kudos

[v-binbinyu-msft]

Hi @mina97 ,

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or if you are still confused about it, please feel free to let me know.

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Sahir_Maharaj · Accepted solution]

Hello @mina97,

Can you please try this:

1. Calculate the Number of Unique Names per ID

UniqueNameCount = 
COUNTROWS(
    SUMMARIZE(
        FILTER(
            ALL(Table),
            Table[id] = EARLIER(Table[id])
        ),
        Table[name]
    )
)

2. Create a New Column to Indicate if an ID has Multiple Names

MultipleNamesFlag = 
IF([UniqueNameCount] > 1, TRUE(), FALSE())

Once you've created these measures/columns, you can add the MultipleNamesFlag column to your table visual or use it as a filter. The resulting output would be:

id         name    MultipleNamesFlag
216000300  jack    T
216000300  noah    T
217000301  jousef  F

Should you require my further assistance, please do not hesitate to reach out to me.

[Dangar332 · Accepted solution]

hi, @mina97 

try below code 

result =

var a =CALCULATE(DISTINCTCOUNT('Table'[name]),ALL('Table'[name]))

return

IF(a>1,"F","T")

adjust your table name

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly. Appreciate your kudos