Multiple filter conditions

[Anonymous]

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 category	Company subcategory
A	1	25
B	1	28
C	1	33
D	1	33
E	1	-
F	2	18
G	2	-
H	2	-
I	3	12
J	4	33

I need to filter out companies:

1. Company category = "2"
OR
2. Company category = "1" AND Company subcategory = "33"

This is too much for the regular Power BI filter options so I need DAX.
I tried a query with CALCULATEDTABLE but I got the scalar value vs multiple value error.

Any ideas?
Thx in advance!

[parry2k]

@Anonymous try following measure

Your Measure = 
CALCULATE( SUM(Table[Sales]),
Company[Company Category]="2" ||
AND( Company[Company Category] = "1", Company[Compay Subcategory]="33")
)

[Anonymous]

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

[parry2k]

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

[Anonymous]

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]

@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]

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