need to get count per computer name per group

[Abdelrahman Abdou]

HI,
I have a dataset that looks as follows:

Computer Name | Number of Cores | Group
Computer 1 | 2 | Group 1
Computer 2 | 4 | Group 2
Computer 3 | 6 | Group 3
Computer 1 | 2 | Group 1


I need to build a DAX calculated column that can get me the number of cores per computer per group. I need the formula to ignore duplicate computers (The data could contain duplicate computers) and count the cores on the first occurrence only. Let me know if you need any further information.


Regards,
Abdelrahman

 

[macfuller]

You might consider using PowerQuery to eliminate duplicates.

Would different computers be in the same group? For example, Computer 5 with 4 cores might be in group 1. In that case would you want an average of the cores per computer in group 1 (4 + 2)/2 = 3?

 

[Abdelrahman Abdou]

You might consider using PowerQuery to eliminate duplicates.

Would different computers be in the same group? For example, Computer 5 with 4 cores might be in group 1. In that case would you want an average of the cores per computer in group 1 (4 + 2)/2 = 3?

yes, Eliminating the duplicates is the way to go. Thanks a lot for your help

Regards,
Abdelrahman