Set expression with availability to filter down

[iczkla]

Hello,

I have a simple set analysis expression in which I am counting IDs for products from chosen categories:

Count(distinct{<[Category]={'7','8','9')}>}[ID])

Unfortunately using set analysis like this restricts me from filtering down to only see results for one of those. Is there a way to make this more flexible - measure by default showing result only for 3 categories but also allowing to filter down for example only for 7?

Thank you for any help

[MayilVahanan · Accepted solution]

HI

Try like below

Count(distinct{<[Category]*={'7','8','9'}>}[ID])

[Prem0212]

I am giving you the example set analysis expression. I hope this works for you.

Count({<[Region]={'Central','East','South'}>}distinct [Product ID])

Please like and accept the solution if u find an answer