Trying to create a measure to calculate the rows with specific names under the same column name

[ibrahimMurtala]

I have tried using the formula  

Supply Chain = CALCULATE([Total],CRIMs[Business Area Affected]= "supply chain management") but when i try to do a + to add "shipping" + purchasing/logistics

[ibrahimMurtala]

Thank you, this worked, I also used the following function which worked as well:

CALCULATE([Total_CRIMS],FILTER(CRIMs, CRIMs[Business Area Affected] = "Shipping" || CRIMs[Business Area Affected] = "Purchasing/Logistics" || CRIMs[Business Area Affected] = "Supply Chain Management"))

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure how your semantic model looks like, but I tried to create a sample pbix file like below.

Please check the below picture and the attached pbix file.

KEEPFILTERS function (DAX) - DAX | Microsoft Learn

DAX operators - DAX | Microsoft Learn

Value total measure: = 
SUM( CRIMs[Value total] )

expected result measure: = 
CALCULATE (
    [Value total measure:],
    KEEPFILTERS ( CRIMs[Business Area Affected] IN { "supply chain management", "shipping" } )
)