dax formula filter help

[Anonymous]

Hey everyone, 

i am new to DAX and need help on a formula i need to combine three quick formulas into one basically they are three filters for the sum of sales

CALCULATE(

    COUNTA('SheetA'[Sum of Total sales),

    'SheetA'[Clarity Cost Center] IN {

        "10003534",

        "10003955",

        "10004479",

        "10020143",

        "10020189",

    }

)

||'SheetA'[Status]

        IN { "OK", "OK. Project Changed" }

||'SheetA'[Month] IN { BLANK(), "4/1/2020" }

Thank you in advance 

[harshnathani]

Hi @Anonymous ,

Please share sample data and expected output.

You can try this measure

Measure =
MAX ( 'SheetA'[Clarity Cost Center] )
    IN {
    "10003534",
    "10003955",
    "10004479",
    "10020143",
    "10020189"
}
    || MAX (
        'SheetA'[Status]
            IN {
            "OK",
            "OK. Project Changed"
        }
            || MAX ( 'SheetA'[Month] )
                = BLANK (),
        SUM ( 'SheetA'[Sum of Total sales] )
    )

Regards,

Harsh Nathani

Appreciate with a Kudos!! (Click the Thumbs Up Button)

Did I answer your question? Mark my post as a solution!