topic Measure counting rows using multiple filters using a related table in DAX Commands and Tips

Measure counting rows using multiple filters using a related table

Anonymous — Tue, 14 Mar 2023 17:13:31 GMT

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! 🙂

Re: Measure counting rows using multiple filters using a related table

tamerj1 — Tue, 14 Mar 2023 18:10:58 GMT

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

Re: Measure counting rows using multiple filters using a related table

Anonymous — Wed, 15 Mar 2023 10:33:03 GMT

Hello tamerj1

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