Conditional view of set analysis query in straight table

[#1]

Hi,

Please can someone help with my query?

I have a straight table in Alternate State 'Regular' with:

Dimension: Customer ID

Expressions: sum({[Analysis Group 1] * $}[Product Ordered]) , sum({[Analysis Group 2] * $}[Product Ordered])

Customer   ID	sum({[Analysis Group 1] * $}[Product Ordered])	sum({[Analysis Group 2] * $}[Product Ordered])
1	100	50
2	0	80
3	60	0
4	50	75

I want to only diplay rows where sum({[Analysis Group 1] * $}[Product Ordered]) > 0 and sum({[Analysis Group 2] * $}[Product Ordered]) > 0 so my table looks like:

Customer   ID	sum({[Analysis Group 1] * $}[Product Ordered])	sum({[Analysis Group 2] * $}[Product Ordered])
1	100	50
4	50	75

How do I do this please?

Thanks

[tresesco]

Copy your condition, goto presentation tab, Select the first expression under column, select 'Conditional', put the expression, select the second expression and put the same expression selecting conditional.

hope this helps

[#3]

Thanks.  That works for each of my expressions separately, but not when I combine them.  I need both sum({[Analysis Group 1] * $}[Product Ordered]) > 0 and sum({[Analysis Group 2] * $}[Product Ordered]) > 0 for the row to display.  Any thoughts?

[simondachstr]

sum({[Analysis Group 1] * $}[Product Ordered])*sum({[Analysis Group 2] * $}[Product Ordered])>0 maybe?

[#5]

No that doesn't work either.  I am wondering whether I need to use a calculated dimension?

[tresesco]

Have you tried putting the combined expression as the conditional expression(presentation tab) for both of the expressions like:

=sum({[Analysis Group 1] * $}[Product Ordered]) > 0 and sum({[Analysis Group 2] * $}[Product Ordered]) > 0

?

[#7 · Accepted solution]

Yes and unfortunately that didn't work.

I have however figured it out!  I defined the expression as:

if(sum({[Analysis Group 1] * $}[Product Ordered])>0 and sum({[Analysis Group 2] * $}[Product Ordered])>0,sum({[Analysis Group 1] * $}[Product Ordered])

and similarly for sum({[Analysis Group 2] * $}[Product Ordered]).

I then ensured that suppress zero values and suppress missing were checked for my dimension and expressions.

Thanks for all your help.