cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Route11 Member
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
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
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 !





Route11 Member
Member

Re: Calculation based on filter

many thanks- let me test.