How to add 2 Different Dimension Condition in Filter Expression

[Varun51]

HI,

Would like to 2  Different Filter conditions in FIlter expression like below . is it possible ?

any help would be highly appreciated

in below DAX would like to add condition from another table Category = "Produce") 

Filter Measure = CALCULATE([Tot Sales Measure], FILTER( Products, Products[ProductName]= "Tofu" || cat))

Thanks,

Varun

[amitchandak]

Try like

Filter Measure = CALCULATE([Tot Sales Measure], FILTER( Products, Products[ProductName] in { "Tofu" , "cat"}))

or

Filter Measure = CALCULATE([Tot Sales Measure], FILTER( Products, Products[ProductName] = "Tofu" || Products[ProductName] = "cat"))

[Varun51]

HI Amit,

Thanks for your reply

would like to conditon for different  table not from same table like product name

It should be like below is this possible conditions from 2 different tables ?

Filter Measure = CALCULATE([Tot Sales Measure], FILTER( Products, Products[ProductName] = "Tofu" ||Category[Category Name] = "Produce"))

[v-xuding-msft · Accepted solution]

Hi @Varun51 ,

Please try like this:

Filter Measure =
CALCULATE (
    [Tot Sales Measure],
    FILTER (
        Products,
        Products[ProductName] = "Tofu"
            || MAX ( Category[Category Name] ) = "Produce"
    )
)

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Varun51]

Thats grate working like a Charm !!.

May i know why we need to use Max here can you please help me in understanding?

Thanks,

Varun