KPI - Exclude a value in a dimension

[Phara]

Hello,

I need a formula that needs to count a purchase order excluding one value in a dimension.

In my dimension [HA Description Action] their are 3 values : Active, Canceled, Pending

A purchase order can have 2 statues : Canceled and Pending. The dimension is  [Num BC]

I want to count the purchase orders that are canceled BUT not Pending.

I tried : count(distinct (if ([HA Description Action]='Active', not match ([HA Description Action]='Pending', [Num BC])))

Please hep me

[MatheusC]

@Phara 

use the -= sign

ex:

count(distinct ({<[HA Description Action]-={'Pending'}>}[BC Number])

Att,

Matheus

[MatheusC]

@Phara 

The subject of the topic being resolved, close the topic with the solution found.

Thanks,
Matheus

[magellan · Accepted solution]

Maybe try

count(distinct(if( HA Description Action] = 'Active' AND [HA Description Action] <> 'Pending',[Num BC])))

[Ahidhar · Accepted solution]

try this 

count({<[HA Description Action]- ={'Pending'},[HA Description Action]={'Active' } >}distinct [Num BC])

[Phara]

Thanks alot! It works 😃