Forum Discussion

alonb's avatar
alonb
Helper I
8 years ago

Expression or between two filters

Hi,

 

I came across the issue that I can not find a solution.

 

I have two fields one "Location" and the other a "GroupName", both are shown as filters (Slicers) in the report.

Is there a possibility between these two filters would be a connection of or (not And) between them ?

For example, I want to see all customers whose location is New York or they are in the Developers group name.

 

 

Thank you for the help

 

Best regards,

Alon

 

1 Reply

  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support

    Hi alonb

    After researching and testing, I still find no direct option to do this, I’m afraid it is not possible to do in Power BI, you can submit an idea here to improve our product.

    Additionally, your requirement of your example can be achieved by DAX with function CALCULATE and OR.

     

     

    Best Regards

    Maggie