Multiple Condition and get the unique data

Hello All

I would like to ask what is the correct formula on how to get the unique count of Entity ID based on the condition:

Get the total count of Entity id based on specific week, High Severity and ABC KPI. I have attached the expected result.

Thank you in advance.


Original title: Count ifs formula