topic calculated column from having only certain value in DAX Commands and Tips

calculated column from having only certain value

mmh — Mon, 19 Aug 2024 11:43:32 GMT

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 certain activity name. here in below sample data in every id's have activity name abc along others name, but id 2 only have only abc value. so calculated column should be type B for id 2 other id type A.

id	activity name	calculated column
1	abc	Type A
1	xyz	Type A
1	xy	Type A
2	abc	Type B
2	abc	Type B
3	abc	Type A
3	xy	Type A
3	py	Type A

Thanks in Advance

Re: calculated column from having only certain value

sjoerdvn — Mon, 19 Aug 2024 12:14:40 GMT

you haven't mentioned the table name, so for the example below I used "applications":

calculated column = IF(CALCULATE(DISTINCTCOUNT('applications'[activity name]),ALLEXCEPT('applications','applications'[id])) = 1, "Type B", "Type A")

Re: calculated column from having only certain value

mmh — Mon, 19 Aug 2024 12:27:11 GMT

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

Re: calculated column from having only certain value

sjoerdvn — Mon, 19 Aug 2024 12:37:38 GMT

ok, then try:

calculated column = IF(CALCULATE(DISTINCTCOUNT('applications'[activity name]),ALLEXCEPT('applications','applications'[id]), 'applications'[activity name] <> "abc") >0, "Type A", "Type B")