Calculation based on filter

[Anonymous]

Hi Experts

How would you work out the following: i want to work out the net sales that are orangic for the following companies A, B  and C

my measure so far is

Organic Element Correction (symbias and EuroTech) = CALCULATE(
        [Net Sales BM],
        FILTER( InOrganic,InOrganic[InOrganic]= "organic"),'Legal Entity','Legal Entity'[Legal Entity Name]="A","B","C")

cannot see the error

[PattemManohar · Accepted solution]

@Anonymous Try using IN operator while comparing multiple values

Organic Element Correction (symbias and EuroTech) = CALCULATE(
        [Net Sales BM],
        FILTER( InOrganic,InOrganic[InOrganic]= "organic"),'Legal Entity','Legal Entity'[Legal Entity Name] IN {"A","B","C"})

[Anonymous]

many thanks- let me test.