Forum Discussion

Varun51's avatar
Varun51
Regular Visitor
6 years ago
Solved

How to add 2 Different Dimension Condition in Filter Expression

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 anot...
Need Help
  • v-xuding-msft's avatar
    v-xuding-msft
    6 years ago

    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.

v-xuding-msft's avatar
v-xuding-msft
Icon for Community Support rankCommunity Support
6 years ago

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's avatar
Varun51
Regular Visitor
6 years ago

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