How to select a field within by bookmark excluded Values

[Joachim]

Hi,

i have created a selection of data according multiple fields selections, and now i want to create specific lists of what i have exlcuded, by using a field value. I try this, on a KPI to check the amount:

count({-BM_Choice <SubComCodeDesc2={'Chain'}>}[Part Number])

But when i add the modifier SubComCodeDesc2, the count goes up, instead of down when selecting a subset.

What do i do wrong here?

Thanks!

[Chanty4u]

You have to modify your expression

count({<SubComCodeDesc2 -= {'Chain'}>} [Part Number])

[Joachim]

---

@Chanty4u wrote:

You have to modify your expression

count({<SubComCodeDesc2 -= {'Chain'}>} [Part Number])

---

I have tried it, but leads to the wrong result. 

count([Part Number])

= 5.760

count({-BM_Choice}[Part Number])

=1.288 , what is proofed as the right amount of excluded values

count({-BM_Choice <SubComCodeDesc2 -= {'Chain'}>}[Part Number])

=2.538, what doesnt hit the expected result. The result have to be lower than 1.288, because i want to select witin 1.288 

count({-BM_Choice <SubComCodeDesc2 = {'Chain'}>}[Part Number])

=4.510, what is also not the result i am look for. 

[marcus_sommer · Accepted solution]

I never applied such logic and therefore I'm not sure about the right syntax but I think you need to connect the conditions respectively data-sets explicitly with an operator. By a quick test seems the following logic be working:

count({-BM_Choice * <SubComCodeDesc2 -= {'Chain'}>}[Part Number])

[Joachim]

It was the * Operator what made it work. The Modifier than has to be without "-"minus.

count({-BM_Choice * <SubComCodeDesc2 = {'Chain'}>}[Part Number])

=515

I also can add now multiple modifiers and result in a subset  of the exlcuded bookmark selection -BM_choice

count({-BM_Choice*<SubComCodeDesc2 = {'Chain'}, LAENGE={'3'}>}[Part Number])

=7

Thanks Marcus!