Then, the costumer asked for the field 'origem_lab' to be displayed and work as a filter. But the set analysis ignores values selected for the above expression.
Is there a way to make this set analysis expression variable based on values selected in origem_lab?
Your measure is ignoring selections on origem_lab field because you forced it to be equals zero in your expression: sum({$<ind_smm = {'Executante'},origem_lab={0}>} v_voc_rat).
To avoid this behavior, simply remove that set expression from your measure:
You are using origem_lab as as a modifier in your set expression. Filtering on that value 0 (zero).
Which filters are you expecting your expression to calculate over when you make a selection in that field?
Lets assume you select origem_lab=1. Are you then expecting the sum of v_voc_rat where ind_smm is 'Executante' and origem_lab is 0 or 1? Or other? Please explain.
Your measure is ignoring selections on origem_lab field because you forced it to be equals zero in your expression: sum({$<ind_smm = {'Executante'},origem_lab={0}>} v_voc_rat).
To avoid this behavior, simply remove that set expression from your measure:
You are using origem_lab as as a modifier in your set expression. Filtering on that value 0 (zero).
Which filters are you expecting your expression to calculate over when you make a selection in that field?
Lets assume you select origem_lab=1. Are you then expecting the sum of v_voc_rat where ind_smm is 'Executante' and origem_lab is 0 or 1? Or other? Please explain.
