Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Measure counting rows using multiple filters using a related table

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 {"...
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
3 years ago

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" } )
)
)