Help with DAX: Using Filters

[Anonymous]

Hi, 

I have the below DAX formula but I cannot think of a way to include multiple values that the Minority Indicator Code can be. 

My formula so far:
Count of Minority Vendors = CALCULATE(DISTINCTCOUNT(Materials[Primary Vendor Number]), Materials[Minority Indicator Code] = "MBE"


What the other acceptable options can be for the minority indicator code:

Basically anything but blank can be accepted.

Any help is appreciated!

[sergej_og · Accepted solution]

Hey @Anonymous ,
hope I got your issue right. Have you already tried to use the IN operator.
You can provide several values to your DAX.
Smthg like this:

CALCULATE(
    DISTINCTCOUNT(Materials[Primary Vendor Number]),
    Materials[Minority Indicator Code] IN {"MBE", "SB", "WBE", "WOS"}
)

Regards