cancel
Showing results for
Did you mean:
Highlighted
Member

## Calculation based on filter

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

1 ACCEPTED SOLUTION

Accepted Solutions
Super User

## Re: Calculation based on filter

@Route11 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"})```

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

Proud to be a Datanaut !

2 REPLIES 2
Super User

## Re: Calculation based on filter

@Route11 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"})```

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

Proud to be a Datanaut !

Member

## Re: Calculation based on filter

many thanks- let me test.