Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
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.
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,