Count number of companies NOT ordering certain jobs

[PeterStuhr]

Hi all!

I have a company table with company data, and a turnover table with all our sales lines including what job type it is.

I am interested in how to calculate number of companies BUYING a certain job type.

And how to calculate number of companies NOT BUYING a certain job type.

So I can make some percentage measure.

Data could look like this.

Company table:

CompanyID

1

2

3

Sales table:

CompanyID	JobID	JobTypeID
1	1	1
1	2	1
1	3	1
1	4	2
1	5	1
2	6	2
2	7	2
2	8	2
2	9	1
2	10	1
3	11	1
3	12	1
3	13	1
3	14	1
3	15	1
3	16	1
3	17	1
3	18	1
3	19	1
3	20	1

thanks!

[PeterStuhr · Accepted solution]

Fixed.. I just made a calculated table in the company table:

Special jobs = CALCULATE(DISTINCTCOUNT(FactTurnover[TurnoverJobId]);FactTurnover[TurnoverJobTypeId]=1|| FactTurnover[TurnoverJobTypeId]=2||)

Everyone blank are the ones I am looking for