Forum Discussion

Jigar1276's avatar
Jigar1276
Icon for Helper I rankHelper I
4 years ago
Solved

Add new column to show unique counts

Hi, I have following sample table "ProjectTracking" in which I am trying to add the new column which is in red box: New column named "Single or Multiple" should show if Assignee is working on...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Jigar1276 Try this:

    NewColumn=var CurrAssignee='table'[Assignee]

    var CountProject=COUNTROWS(SUMMARIZE(FILTER('table','table'[Assignee]=CurrAssignee),'table'[Project Name]))

    return IF(CountProject=1,"Single Project","Multiple Projects")

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Jigar1276 Try this:

NewColumn=var CurrAssignee='table'[Assignee]

var CountProject=COUNTROWS(SUMMARIZE(FILTER('table','table'[Assignee]=CurrAssignee),'table'[Project Name]))

return IF(CountProject=1,"Single Project","Multiple Projects")

Jigar1276's avatar
Jigar1276
Icon for Helper I rankHelper I
4 years ago

Brilliant. This worked as a charm.