help with set analysis

[josemaria_cabre]

Hi everyone!

Let's imagine I have following dimensions in my model:

Market
Product_group
Department

...+ 100 more dimensions

and this measures:
units
price

If I want to create a KPI which must not be filtered by e.g. 'Market' and 'Department', I'd use this formula:

Count({<Market = , Department= >} units)

Which formula should I use, if I want units to be filtered ONLY by dimension 'Product group', ignoring the +100 dimensions in my model? Is that possible?

Thanks in advance,
Jose.

[micheledenardi · Accepted solution]

Try this:

Count({1<[Product group]= $::[Product group]>}units)

Source : Set Analysis: Ignore All Selections except for one field

[josemaria_cabre]

Worked perfect!

Thank you Michele