topic Re: Posting this to correct topic (DAX CALCULATION CREATE A COMPLEX FILTER THAT HAS many AND'S / OR'S in DAX Commands and Tips

Posting this to correct topic (DAX CALCULATION CREATE A COMPLEX FILTER THAT HAS many AND'S / OR'S

Anonymous — Mon, 16 May 2022 19:13:51 GMT

I need to write a calcuate (sum) using this filter.

I have tried to figure out a way to do this is DAX filter but it doesn't like parenthesis in the filter.

Any ideas would be very appreciated.

(Filter A = "b" or Filter B = "b") and Filter C = "x" and (filter D = "1" or filter D ="2")

Re: Posting this to correct topic (DAX CALCULATION CREATE A COMPLEX FILTER THAT HAS many AND'S / OR'S

amitchandak — Tue, 17 May 2022 02:00:20 GMT

Anonymous For and use && and For OR is || , use in for or of same filter

([Filter A] = "b" || [Filter B] = "b") && [Filter C] = "x" && ([filter D] in{ "1" ,"2"} )

Re: Posting this to correct topic (DAX CALCULATION CREATE A COMPLEX FILTER THAT HAS many AND'S / OR'S

Anonymous — Tue, 17 May 2022 13:41:19 GMT

Hello,

Thanks for the reply but it will not allow me to do what you advised. Below is the image of the error I get.

Re: Posting this to correct topic (DAX CALCULATION CREATE A COMPLEX FILTER THAT HAS many AND'S / OR'S

Anonymous — Tue, 17 May 2022 13:43:54 GMT

Hello,

Thanks for the reply but it will not allow me to do what you advised. Below is the image of the error I get.

Re: Posting this to correct topic (DAX CALCULATION CREATE A COMPLEX FILTER THAT HAS many AND'S / OR'S

Anonymous — Thu, 19 May 2022 07:41:12 GMT

Hi Anonymous ,

Try this measure.

Measure = CALCULATE( DISTINCTCOUNT('Main'[ID]), FILTER('Main', ('Main'[ADMITSTATUS]="N"||'Main'[ETHNICITY]="N") &&'Main'[CITIZEN]="Y" ) )

If this doesn't work for you, would you mind sharing a sample data without privacy and tell me what data you want to filter out? Thanks in advance.

How to provide sample data in the Power BI Forum

How to Get Your Question Answered Quickly

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data

Re: Posting this to correct topic (DAX CALCULATION CREATE A COMPLEX FILTER THAT HAS many AND'S / OR'S

Anonymous — Thu, 19 May 2022 14:47:32 GMT

Thanks that worked.