calculate sum with multiple criteria

Hi alsm ,

There are many ways to write this, however this works:

Sum =
CALCULATE (
    SUM ( IndustryResearch[Volume] ),
    FILTER (
        IndustryResearch,
        IndustryResearch[Industry]
            IN { "Energy Equipment & Services", "Oil, Gas & Consumable Fuels" }
            && IndustryResearch[Sub-Industry] = "Drilling"
    )
)
    + CALCULATE (
        SUM ( IndustryResearch[Volume] ),
        FILTER (
            IndustryResearch,
            IndustryResearch[Industry] = "Metals & Mining"
                && IndustryResearch[Sub-Industry] = "Diversified Metals & Mining"
        )
    )

Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel