How to exclude field from set analysis, but not exclude it as a filter in terms of filtering out fields?

[ledi12]

Hi,

I have a measure where I need to exclude one field which is month, when calculating revenues.

sum({<Month=, Product={'1', '2'}>}Revenues)

It works, but it also excluded month from filter pane -> It displays all data, month filter has no effect.

How can I make it working? Exclude month from set analysis, but keep it as a working filter pane ?

[Mark_Little]

HI @ledi12 

Not sure what you are meaning as what you have done does that.

Adding Month= to your set expression, means ignore Month for this measure. If you select month it will still filter for everything else.

[RafaelBarrios]

Hi @ledi12 

as it’s not clear what you are trying to do, you could try using a variable to override this.

vSetMonthField

=if(getSelectedCount(Month)=0,'Month=,','')

and your measure could be:

sum(total {< $(vSetMonthField)Product={'1', '2'}>}Revenues)

but we can help better if you paste an example of what you are trying to do.

my guess is that you have month as dimension and you want to do a total column, and for that you will need to use an aggr() in you measure.

hope this help.

best,