topic Re: Set Analysis filter not working in App Development

Set Analysis filter not working

pedromsouza — Sun, 12 Oct 2025 20:14:28 GMT

Hi,

I made this expression and it's working as expected:

sum({$<ind_smm = {'Executante'},origem_lab={0}>} v_voc_rat)

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?

Re: Set Analysis filter not working

marksouzacosta — Sun, 12 Oct 2025 21:58:32 GMT

Hi @pedromsouza,

Are you from Brazil?

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:

sum({$<ind_smm = {'Executante'}>} v_voc_rat)

Regards,

Mark Costa

Re: Set Analysis filter not working

Vegar — Sun, 12 Oct 2025 22:04:17 GMT

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.