DAX for using FOR EACH function

Pls help to create DAX query for the following requirement....

Requirement - Change the Color of State on Map according to the status of City with respect to the Air Quality and Water Quality parameters.

Each State has approx 100 cities

Each City has several Air Quality and Water Quality parameters.

If Water Quality is Ok for all the cities in that State, then check Air Quality, if OK then Green Else Yellow, else Red(if water quality is OK).

Thanks in Advance.....