Create a flag for each id having duplicate values using Dax

[shoeb1359]

Hello Experts,

I have stucked in a scenario where i need to create a language flag for each id using dax

Thanks in advance

ID	Language	Language Flag  (Output)
1	English	Bilingual
1	Arabic	Bilingual
2		NA
3	English	monolingual
4	Arabic	monolingual
5	Arabic	Bilingual
5	English	Bilingual

[FlipFlop1]

DAX:

Language Flag =

        VAR LanguageCount = CALCULATE(COUNT(Table1[ID]),ALLEXCEPT('Table1',Table1[ID]))

        RETURN

        IF(Table1[Language]=BLANK(), "NA",

        IF(LanguageCount=1, "Monolingual",

        IF(LanguageCount=2, "Bilingual")))

[ryan_mayu · Accepted solution]

@shoeb1359 

you can try this

Column =

var _count=CALCULATE(DISTINCTCOUNT('Table'[Language]),ALLEXCEPT('Table','Table'[ID]))

return if(_count=1 && 'Table'[Language]="","NA",if(_count=1,"monolingual","Bilingual"))