
1. Re: If 2 statements are true
Jim Dehner Sep 19, 2019 2:53 PM (in response to Victor Namnum)you want to look at the Product level so if you write {fixed [product]: max( if(IF [Region] = "South" AND [Profit]<0 THEN 1 END )}
should return a 1 for any product (in this case Chairs although it will look at each product independently  ) where the profits in the south are negative
Jim
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.

2. Re: If 2 statements are true
Deepak Rai Sep 19, 2019 3:05 PM (in response to Victor Namnum){FIXED Product:MAX(IF [Region] = "South" AND [Profit]<0 THEN 1 END)}

3. Re: If 2 statements are true
Hesham Eissa Sep 19, 2019 6:35 PM (in response to Victor Namnum)you would need to use: Int( { Fixed [Product] : max ( Region = 'South' AND [Profit] < 0 ) } )

4. Re: If 2 statements are true
Victor Namnum Sep 20, 2019 7:02 AM (in response to Jim Dehner)My 'Profit' is calculation and I get the error "level of detail cannot contain table calculations." What would the solution to this be? The calculation is actually pretty robust, so I may have to spend some time on applying the solution.

5. Re: If 2 statements are true
Jim Dehner Sep 20, 2019 7:04 AM (in response to Victor Namnum)Victor 
don't know with seeing the actual calculation for Profit  it is why we want you to include your twbx workbook
Jim

6. Re: If 2 statements are true
Victor Namnum Sep 20, 2019 7:11 AM (in response to Jim Dehner)Thanks Jim. Conceptually, can you maybe explain what I should try an do as fix? The 'profit' is actually a predicted profit based on various calculations. For example, would the solution, directionally, be that I apply the 'FIXED' LOD to the initial calculation so that it'll carry to the other calculations that ultimately product the 'profit' calculation?

7. Re: If 2 statements are true
Jim Dehner Sep 20, 2019 7:23 AM (in response to Victor Namnum)Victor
sorry once you are using table calcs the only other calcs they a=can be used in are other table calcs  so my recommendation is to look at how you calculate Profit and see if you can convert that to something that uses lods