Forum Discussion

shoeb1359's avatar
shoeb1359
Icon for Helper III rankHelper III
2 years 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

 

IDLanguageLanguage Flag  (Output)
1EnglishBilingual
1ArabicBilingual
2 NA
3Englishmonolingual
4Arabicmonolingual
5ArabicBilingual
5EnglishBilingual
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    2 years 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"))

2 Replies

  • ryan_mayu's avatar
    ryan_mayu
    Icon for Super User rankSuper User
    2 years 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
    Icon for Advocate I rankAdvocate I
    2 years 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")))