Error when filtering measure by 2 columns

[Anonymous]

The measure I am trying to display is a sales measure and I want to filter by a range of order dates within the last 2 weeks and one brand. I could filter the sales by either one individually and the mesasure would display just fine, but then when I try to filter the measure by both of them using multiple filter conditions, the chart doesn't display and I get this message: "The expressin contains multiple columns but only a single column can be used in a True/False expression that is used as a table filter expression."

I tried two different formulas:

calculate(sales, 'brand'[brand] =  "brand1" || 'order date'[order date] >= today()-14)

and

sumx(filter('brand'[brand] = "brand1") && filter('order date'[order date] >= today()-14), sales)

Same error both ways. Can anyone help me out with what theproblem is and how to work around it?

Note: The sales measure is calculated in the Azure Analysis Services layer.

UPDATE: I changed the calculate formula to:

calculate(sales, 'brand'[brand] =  "brand1", 'order date'[order date] >= today()-14)

Now the chart displays but I am getting a constant value, which is not what I am looking for.

[v-yulgu-msft · Accepted solution]

Hi @Anonymous,

Suppose there existing reationship between 'brand'and 'order date'. Please try this:

Formula =
CALCULATE (
    [sales],
    FILTER (
        'brand',
        'brand'[brand] = "brand1"
            && RELATED ( 'order date'[order date] )
                >= TODAY () - 14
    )
)

Best regards,

Yuliana Gu