Forum Discussion

mmh's avatar
mmh
Icon for Helper I rankHelper I
2 years ago
Solved

calculated column from having only certain value

Hi, there is application dataset contains ,application_id, activity name.. one application i having many multiple activiy name. so i would like have a calculated column if particular id having only ...
  • sjoerdvn's avatar
    sjoerdvn
    2 years ago

    ok, then try:

    calculated column = IF(CALCULATE(DISTINCTCOUNT('applications'[activity name]),ALLEXCEPT('applications','applications'[id]), 'applications'[activity name] <> "abc") >0, "Type A", "Type B")
mmh's avatar
mmh
Icon for Helper I rankHelper I
2 years ago

Hi,
thanks! but i need consider value only i.e abc, as may be other id have distinct value with other value.