Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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"})
Proud to be a PBI Community Champion
@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"})
Proud to be a PBI Community Champion
many thanks- let me test.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
99 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |