Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Help with DAX: Using Filters

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!

Need Help
  • sergej_og's avatar
    sergej_og
    1 year ago

    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

1 Reply

  • sergej_og's avatar
    sergej_og
    Super User
    1 year ago

    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