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

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hello tamerj1 

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

  • tamerj1's avatar
    tamerj1
    Community 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" } )
    )
    )