NoFilter() function for one specific dimension

[Former Member]

Hi,

In my report I have 3 filters defined in the filter bar (Region, Product, Year). I know that I can use the NoFilter-function for a measure to ignore all those filters. But can I also specify one specific dimension to be ignored. Let's say I want that for my measure the filter Region should be ignored, but not the Product or Year filter. If not, is there any workaround (One would be to insert a second query and don't merge on the Region-dimension I think)?

Thanks!

[former_member225163]

Just a thought.. might be helpful..

> First apply NoFilter() function on measure, then it ignores all filter conditions,

> then you use a where condition to restrict to particular Year or Product as follows:

e.g., NoFilter(<measure>) where (Year=2013 and Product="abc")

Thanks,

Bala

[Former Member]

Thanks, but then the other 2 filters couldn't used anymore

[Former Member]

Hi Hans,

what are the other 2 filters which you would like to use..??

If those filters are Year and product you can try to use them in formula using the where clause in the formula as Bala mentioned earlier..

[Former Member]

I don't understand that approach, how do you mean to use it in the where clause? The user should be able to set the filter in the filter bar flexible.

[Former Member]

Something like below for the measure..

=NoFilter([Measure]) where ([Year]=2013 and [Product]="Product1")

[Former Member]

Okay, but then if the user choses Year=2014 in the filter bar, it will show no result.