I have a fact table which contains data about the sales such as what was sold, how much sold, when sold, who sold, how many customers bought particular sold, so on and so forth. You can call that fact table contains raw data. Now I want to apply some exclusion rules on the data (exclude some data based on some rules). For example:
1) exclude sale information about product that few customers (i.e. 5) have bought.
2) exclude sale information about the product that was sold 'online'.
Initially, I thought to create two separate filters containing each rule and then apply to fact table of sales. So, I created a measure something like the following:
When I tried to create it, it throws an error "The expression refers to multiple columns, Multiple columns can not be converted to a scalar value".
I converted the measure into table. Now I have a separate table which is created as the result of running the above command. Then I added the second exclusion rule by using 'and' operator in filter function. Now, I have about 8 to 9 exclusion rules. I dont want to use 'and' operator in filter function.
My question is there a way I could use filter function as measure? Can I use multiple filter function that combined returned the table?