Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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 (symbi...
Need Help
  • PattemManohar's avatar
    PattemManohar
    7 years ago

    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"})
PattemManohar's avatar
PattemManohar
Community Champion
7 years ago

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's avatar
Anonymous
Not applicable
7 years ago

many thanks- let me test.