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

[Anonymous]

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")

[Anonymous · Accepted solution]

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.

[amitchandak]

@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"} )

[Anonymous]

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.

[Anonymous · Accepted solution]

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

[Anonymous]

Thanks that worked.

[Anonymous · Accepted solution]

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.