Count based of Uniques based on another Column

[shawn3474]

I have the information in table 1 (first two columns) on the left.  I am trying to get the counts as listed in table 2 (two columns on the right).  

Project_Name	Has Work to Complete		Team	Count of Projects Still Being Worked On
Project A	Windows		Windows	2
Project A	Windows		Network	1
Project A	Windows		Unix	1
Project A	Windows
Project A	Windows
Project A
Project A
Project B	Windows
Project B	Network
Project B	Unix
Project B	Windows
Project B	Network
Project B	Unix
Project B

[MFelix · Accepted solution]

Hi @shawn3474,

On a table just add both columns on your table starting by the Has Work to Complete, then do a summarization by distinct count of Project_Name will give you the expected result.

If you want you can also make a measure and then add it along with the Team column in a table:

Group count = CALCULATE(DISTINCTCOUNT(Projects[Project_Name]))

Regards,

MFelix

Regards,

MFelix