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