Forum Discussion

shoeb1359's avatar
shoeb1359
Helper III
1 year ago
Solved

Create a flag for each id having duplicate values using Dax

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 ...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    1 year ago

    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"))
FlipFlop1's avatar
FlipFlop1
Advocate I
1 year ago

 

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")))