Countifs in Power BI

[jjasper]

Hello, 

I am looking for the DAX coding to recreate a calculation in excel in Power BI. I currently have a calculation that is: (COUNTIFS(Column1 = "VIllage Name", Column2 = "LTC", Column3 = 3)+COUNTIFS(Column1 = "Village Name", Column2 = "LTC", Column3 = 4))/VillageNameCount

Essentially for each village I want to know how many people answered the question with a 3 or 4 then divide by the number residents who answered a survey for that village. 

I want to be able to just load the information from SQL into Power BI and Power BI do the calculations for me instead of excel. 

Hope this makes sense. 

Thanks