Return count of entries while filtering attributes of other column based on current selection
I am trying to figure how to return the 'Missing Attributes' (see calculation). However the attribute count should be dependent upon which 'Brand' is selected. The relationship between the two tables is created via 'STEP ID' Essentially, my spoken calulation would be If 'Brand' = "1" count 'Missing Attributes' that have either "a" or "x" in the column 'Attribute type base'. If 'Brand' = "2" count 'Missing Attributes' that have either "u" or "x" in the column 'Attribute type base'. Else, show all.
