Counting how many employees have more than one computer

[robofski]

I have extracted data from AD, computer name and managed by.  I can now create a table showing each user and the count of computers they have.  What I'm trying to do next is be able to show how many users have one computer, how many have 2 etc. so I'm trying to count my count!

Suggestions?

[MFelix · Accepted solution]

Hi  @robofski,

Made a sample table with person/computer and did a new table with SUMMARIZE:

Table = SUMMARIZE(Table1,Table1[Person],"#Computer",count(Table1[Computer]))

Then just add the #Computer to your table twice with witout summarize and the other making a count and you will get the result below.

Regards,

MFelix

[robofski]

Thanks @MFelix  I thought SUMMARIZE was going to be the answer but couldn't get my head around how!