Power BI Multiple Filter Criteria

[dreid1011]

Good morning,

I am trying to convert my Access queries to Power BI and I am running into a filter problem. In the image below, in Access, I could define an entire row of criteria, and then another, and another.
In Power BI, I have managed to set up the filter criteria for the yellow fields, but I am unsure how to set up the criteria for the green field. Notice as the ranges for TAXLOT overlap with each row, but they need to be specific to the rest of the criteria on their row. How might I achieve this in Power BI? My Google searches have yielded no results because I don't know the right words to describe the issue for searching.

Thank you

 

[dreid1011]

Solved by combining Year, Township, Range, Section, Q Section, QQ Section columns, converting Taxlot column to whole number and using the following calculated column:

= Table.AddColumn(#"Changed Type2", "FLAG - NEDONNA BEACH AREA", each if [#"MAP"] = "2N1020AB" and [#"MAP - TAXLOT (#)"] >= 101 and [#"MAP - TAXLOT (#)"] <= 10000 then "NB" else
if [#"MAP"] = "2N1020BA" and [#"MAP - TAXLOT (#)"] >= 100 and [#"MAP - TAXLOT (#)"] <= 13800 then "NB" else
if [#"MAP"] = "2N1020BD" and [#"MAP - TAXLOT (#)"] >= 100 and [#"MAP - TAXLOT (#)"] <= 15800 then "NB" else
if [#"MAP"] = "2N1020CA" and [#"MAP - TAXLOT (#)"] >= 300 and [#"MAP - TAXLOT (#)"] <= 12200 then "NB" else "")