Forum Discussion
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
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"})
2 Replies
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"})