Power BI Searchable Database

hi, JaClem 

For your case,  "To make things easier for myself I set it up where each cell had a drop down that would say either "Yes", "No", or 'N/A"." it couldn't be achieved in power bi. power bi is BI tool, It is used to analyze the data but not modify the data. to update data, you need to update it in data source and then refresh dataset in power bi.

And you may try to  this data model:

Dim table: Brands and Colors

Data table: it should be like this:

Then create the relationship with Dim table: Brands and Colors

and then create the measure to count or sum the data table

Now drag dim fields from dim table as aslicer to fiter data.

There many power bi report example and documents for you to refer to:

https://docs.microsoft.com/en-us/power-bi/sample-datasets

Best Regards,

Lin