Selection and Set analysis Issue

[#1]

Hello,

I am having an issue with my set analysis in a chart.  Below is my expression:

=if(_TimePeriod = '1 MONTH', Sum({$<Measure={'TEB'}, ProductId = {1}, IsCurrentMonth = {1}>} Qty),

  if(_TimePeriod = '3 MONTHS', Sum({$<Measure={'TEB'}, ProductId = {1}, Is3Month = {1}>} Qty),

  if(_TimePeriod = '6 MONTHS', Sum({$<Measure={'TEB'}, ProductId = {1}, Is6Month = {1}>} Qty),

  if(_TimePeriod = 'QTD', Sum({$<Measure={'TEB'}, ProductId = {1}, IsQtd = {1}>} Qty)))))

And so when I want to conditionally show another expression:

=if(_TimePeriod = '1 MONTH', Sum({$<Measure={'TEB'}, ProductId = {1,2}, IsCurrentMonth = {1}>} Qty),

  if(_TimePeriod = '3 MONTHS', Sum({$<Measure={'TEB'}, ProductId = {1,2}, Is3Month = {1}>} Qty),

  if(_TimePeriod = '6 MONTHS', Sum({$<Measure={'TEB'}, ProductId = {1,2}, Is6Month = {1}>} Qty),

  if(_TimePeriod = 'QTD', Sum({$<Measure={'TEB'}, ProductId = {1,2}, IsQtd = {1}>} Qty)))))

The Values for ProductId 2 are not showing up and I cannot figure out why.  It seems like I am licked into a weird selection, where productId = 1.

Thank you for your help.

[MK_QSL]

Try

ProductId = {'1','2'}

[#3]

No change, unfortunately

[#4]

Try using multiple expressions and the conditional to calculate each one of those, that way you could also debug it a lot easier