¿How to exclude only one selection?

[#1]

Hi there,

I have some problem when I want to count a values and filter by some selections.

I have the following count:

Count({$<[Status]={'closed'},[Type]={'PC'}>}[Task]))

And I have the following selections:

REGION

CITY

COUNTRY

DATE

I need that the count works with the selections REGION, CITY and COUNTRY, but if I select some value of DATE does not import in the count.

I don't know if I can put in the formule some keyword to block this selection (DATE), ONLY for this count.

Best regards.

[swuehl]

Try to ignore the DATE selection like

Count({$<[Status]={'closed'},[Type]={'PC'}, DATE= >}[Task]))

[engishfaque]

Dear Juan,

When you are writing your set analysis just write your "Field Name with = sign" such as Date =.

So, your requirement is that when you select Date Field no count perform for [Task]. Your expression is right just append with one more modifier ", Date = ". Such as @Stefan shared you set analysis.

Kind regards,

Ishfaque Ahmed

[Chanty4u]

chk dis

Excluding values in Set Analysis

[ben_mckenna]

Did exactly the job for me, thanks! Now my measure responds to any selection the user makes, except for the dimension I've chosen.