need to get count per computer name per group

Abdelrahman Abdou

New Member
Joined
Apr 29, 2017
Messages
2
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
 

Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)

macfuller

Active Member
Joined
Apr 30, 2014
Messages
299
Office Version
  1. 365
Platform
  1. Windows
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?
 
Last edited:

Abdelrahman Abdou

New Member
Joined
Apr 29, 2017
Messages
2
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
 

Forum statistics

Threads
1,148,108
Messages
5,744,876
Members
423,907
Latest member
zerocool88

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top