Syntax assistance with a Filter that has multiple AND / Or conditions

Hi EZimmet ,

I create a table as you mentioned and use your DAX codes, it gives me the same error.

So I think you can change your DAX code and here is the DAX code:

Testing VAR _count = 
COUNTROWS (
    FILTER (
        FILTER (
            FILTER (
                '_Rack Metrics Report',
                '_Rack Metrics Report'[Site] = "123XXX"
            ),
            '_Rack Metrics Report'[DisplayLabel] = "Live"
        ),
        '_Rack Metrics Report'[_All Rack Conditions] = "Installed Client Used"
        || '_Rack Metrics Report'[_All Rack Conditions] = "Installed Empty Powered Available"
        || '_Rack Metrics Report'[_All Rack Conditions] = "Installed Empty Not Powered"
    )
)

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.