Counting rows by company and by status

[slounsbury]

I am needing to create a count of how many active workstations each company has. I cant create a report to show the devices but I am needing it to divide by another number to create an efficiency variable. Here is what my table looks like:

Config_Name	Company_Name	Status_Name	Config_RecID
CGROEN-KHSC	KCIC	Active	4494
Dell TZ300 18B169042B94	KCIC	Active	5391
DESKTOP-07OH4B6	KCIC	Active	5355
DESKTOP-7H24RDJ	KCIC	Active	6553
DESKTOP-DNN9FJM	KCIC	Active	5331
DESKTOP-TVSVF4P	KCIC	Active	5326
iPad Air 2 (WiFi + Cellular) DMPS6A2MG5WQ	KCIC	Active	5329
iPad Air 2 (WiFi + Cellular) DMPS6B62G5WQ	KCIC	Active	5330
KHCLT05	KCIC	Active	4511
KHCLT06	KCIC	Inactive	4506
KHCLT10	KCIC	Active	4502
KHCLT13	KCIC	Active	4512
KHSC01	KCIC	Active	4504
KHSC03	KCIC	Active	4659
KHSC-1	KCIC	Inactive	4495
KHSCLT07	KCIC	Active	4510
KHSCLT16	KCIC	Active	4523
KHSCLT25	KCIC	Active	4525
KHSCLT30	KCIC	Active	6466
LAPBECKY	KCIC	Active	7084
LAP-DOCHS	KCIC	Inactive	5058
LAPJANEA	KCIC	Active	5061
LAPJENNY	JD	Active	5060
LAPKARLA	JD	Active	6979
LAPKATHRYN	JD	Active	4520
LAPMARLO	JD	Active	7315
LAPMMOSSHART	JD	Inactive	4400
LAPRANDI	CI	Active	6980
LAPRHONDA	CI	Active	6554
LAPSARA	CI	Active	5109
LAPSHAWNA	CI	Active	7299
LAPSTACEY	CI	Inactive	7304
LAP-VICKI	CI	Active	6418
LAP-YHURD	CI	Active	6779
SHAWNA-SPARE	CI	Active	5227
SHELLEY-LAPTOP	CI	Active	5522

I want a column or sorts to list

KCIC - 22

JD - 5

CI - 9

Thanks! 

[Anonymous · Accepted solution]

Hi @slounsbury

Can you try this measure?

Cnt = CALCULATE(COUNT(Table1[Company_Name]),FILTER(Table1,Table1[Status_name] ="Active"))

Thanks

Raj