Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Multiple filter conditions

Hi,   I got the table DimCompanyHis (it contains more columns but these are not relevant for the filtering). company category and company subcategory are textual columns. Company name Company...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi parry2k ,

I used the query (and changed the corresponding columns) and got the following error:
"The expression contains multiple columns, but only a single column can be used in a True/False expression that is used as a table filter expression." 

Why can't AND handle this?

parry2k's avatar
parry2k
Super User
7 years ago

Anonymous missed to add filter

 

Your Measure = 
CALCULATE( SUM(Table[Sales]),
FILTER(
Company,
Company[Company Category]="2" ||
AND( Company[Company Category] = "1", Company[Compay Subcategory]="33")
)
)
  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    parry2k I still don't understand what the correct query is and why I need SUM. 
    SUM gives me an error since my data consists of strings instead of numbers.

    But if I don't use the SUM I get the following error: "The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value".