visualizations filters multiple grouped conditions

I have a report that needs to include data based upon multiple filter conditions and I cannot figure out how to do it in Power BI. Here is the a simple example of what I want to do if I had written it in SQL. Select category, product, type, sum(sales_amt) from sales where category = vehicle and (type = 'car' and (product = 'Nissan' or product = 'Toyota') and (product <> 'Honda')) or (type = 'truck' and product = 'Honda') group by category, product, type; In Power BI with the filters I can set the filter to say type = car, and truck and product = Nissan, Toyota, or Honda but I cannot figure out how to set the or conditions where the filter conditions are grouped together and dependent upon other filters. One more question the filters: When I select the advanced filtering option I can enter in 2 conditions for that one field but there are many times I need to enter in more than 2 conditions (ex: does not contains "blue", "red", "yellow", or "orange" Thank you...