Option to use multiple ifs condition or countifs in QuickSight

Is there an option to use multiple ifs condition or countifs in QuickSight? I’m trying to select all those ids that meet two conditions in two separate columns.
For example
id. status-1. status-2

  1. yes on
  2. yes off
  3. no. off

So I need all ids with status-1 yes and status-2 on.

Hi

you can your AND or OR operators etc.