Measure counting rows using multiple filters using a related table

[Anonymous]

Hello,

I want to createt a COUNTROWS measure for 'IP_MAIN_VW' table that filters column 'IP_MAIN_VW[Discharge Hour]' with '<12' and filters in a related table 'IP_WARDS_VW[DISCH_WARD_CODE]' in {"DIS, "PLG"}.

I can create two separate measures that work OK:

1. CALCULATE(COUNTROWS(IP_MAIN_VW),IP_MAIN_VW[Discharge Hour]<12)

2. COUNTROWS(FILTER('IP_MAIN_VW',(RELATED(IP_WARDS_VW[DISCH_WARD_CODE]) IN {"DIS","PLG"})))

However, I want to combine these filters in one measure, is this possible? I've tried the below and the error states I have too many arguments in the COUNTROWS function. 

Any guidance would be great! 🙂

[Anonymous]

Hello @tamerj1 

Thank you for sharing your solution - this works perfectly! Muchos appreciado! 

[tamerj1]

Hi @Anonymous 

please try

=
COUNTROWS (
FILTER (
'IP_MAIN_VW',
IP_MAIN_VW[Discharge Hour] < 12
&& ( RELATED ( IP_WARDS_VW[DISCH_WARD_CODE] ) IN { "DIS", "PLG" } )
)
)