Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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.
@1984 Is INSTALL a fact and JOB a dimension and both have relationship between them ?
@saurabhtd They are both fact tables and connect via many to one relationship there is a third fact table between the two
User | Count |
---|---|
70 | |
43 | |
21 | |
21 | |
14 |
User | Count |
---|---|
124 | |
42 | |
39 | |
28 | |
25 |