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

Why the SUM?
My category and subcategory are textual values (saying this I know that I could have created better example data:-) ).

parry2k's avatar
parry2k
Super User
7 years ago

Anonymous sum was just to show how to apply or condition in your measures.

  • 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".