Syntex for a count with 2 filters

[EZimmet]

Good day 

I'm off on this syntex if someone an assist please.

 ________________

This works with a single condition:

VAR _ceused =

    COUNTROWS ( FILTER ( ( '_Rack Metrics Report'),'_Rack Metrics Report' [_All Rack Conditions] = "Installed Client Used" ))

_____________________

I need to add a second condition to pull a specfic Site:

VAR _ceused =

    COUNTROWS ( FILTER ( ( '_Rack Metrics Report'),'_Rack Metrics Report' [_All Rack Conditions] = "Installed Client Used" ),

                                          ( '_Rack Metrics Report' ),'_Rack Metrics Report'[Site] = "xxxx"))

   

Too many arguments were passed to the COUNTROWS function. The maximum argument count for the function is 1.

[ToddChitt]

Try nested FILTER statements

FILTER ( FILTER ( ... ) ...)

[EZimmet]

like this ?

Too few arguments were passed to the FILTER function. The minimum argument count for the function is 2.

[ToddChitt · Accepted solution]

You are close. Check your closing ).

FILTER(<table>,<filter>) returns a table. So substitute another FILTER for the table and you get this:

FILTER ( FILTER ( <table>,<filter> ) ,<filter> )

You have this:

FILTER ( FILTER ( <table>   )   ,<filter> ) ,<filter> )

[EZimmet]

I can't thank you enough - your spot on 😀