COUNTROWS USING FILTER ISSUE

1984 — Wed, 24 Jan 2024 13:54:57 GMT

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.

Re: COUNTROWS USING FILTER ISSUE

saurabhtd — Wed, 24 Jan 2024 14:19:49 GMT

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

Re: COUNTROWS USING FILTER ISSUE

1984 — Wed, 24 Jan 2024 16:41:48 GMT

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

topic Re: COUNTROWS USING FILTER ISSUE in DAX Commands and Tips

COUNTROWS USING FILTER ISSUE

Re: COUNTROWS USING FILTER ISSUE

Re: COUNTROWS USING FILTER ISSUE