COUNTROWS USING FILTER ISSUE

[1984]

Hi Community 

Im trying to add an additional filter to an existing countrow + filter column and have some issues I could do with some support if possible.

So my column is currently:

Column = CALCULATE(
COUNTROWS('INSTALL'),
FILTER('INSTALL',
'INSTALL'[Installation_Date__c] = 'Actuals Summary 23-24'[MMM-YY])
)

and I would like to add an additional filter to it I have tried two variations as follows:

COLUMN = CALCULATE(
COUNTROWS('INSTALL'),
FILTER('INSTALL',
'INSTALL'[Installation_Date__c] = 'Actuals Summary 23-24'[MMM-YY])

&&

FILTER('JOB',
'JOB'[Code]="POSS")
)

COLUMN = CALCULATE(
COUNTROWS('INSTALL'),
FILTER('INSTALL', 'JOB',
'INSTALL'[Installation_Date__c] = 'Actuals Summary 23-24'[MMM-YY]||'JOB'[Code]="POSS")
)

Unfortuantely both don't work.

[saurabhtd]

@1984 Is INSTALL a fact and JOB a dimension and both have relationship between them ?

[1984]

@saurabhtd They are both fact tables and connect via many to one relationship there is a third fact table between the two