Removing a Prefixed word from Expression

[mohiahmed]

Hello,

I need to remove everything with "BBDC" from a query, as I need to pick up everything that don't start with "BBDC" in a pivot.

Currently tried this and few other however not working.

=count({<[Exception ID],[Case Sub team]-={"BBDC*"}>}[Exception ID])

Example list below

BBDC London

BBDC East

BBDC West

BBDC South

London

East

West

North

South

Any help with be appreciated.

Thanks

Mohi

[Anonymous]

not sure what you want

if you want to exclude Sub Teams starting with BBDC I would use a calculated dimension

if ((left([case Sub Team],4)<> 'BBDC', [Case Sub Team])

if you want to Report BBDC London to London I would use calcualted Dimension like

if ((left(case Sub Team,4) = 'BBDC', mid(case Sub Team,5, 10), case Sub Team)

your Expression would be

count(Exception ID)

[timpoismans]

From what I can understand, and based on your own measure that you tried, you want to count the Exception ID's of all the Case Sub Teams that don't start with BBDC.

You should try this then:

Count({<[Case Sub Team]=-{'BBDC*'}>}[Exception ID])

Left is a table with random generated Exception ID's, right is a table with my measure.

[prieper]

think, it should be minus followed by the equal:

​Count({<[Case Sub Team] -= {'BBDC*'}>}[Exception ID])

[vishsaggi]

may be this?

= count(IF( Not Wildmatch([Case Sub team], 'BBDC*')>0, [Exception ID])

[timpoismans]

Purely depends on if he wants to make further selections in Case Sub Team or really wants to show all the Case Sub Teams that don't start with BBDC all the time.

=- doesn't take any further selections in Case Sub Team into account

-= does take further selections in Case Sub Team into account

[sasiparupudi1]

May be try

count({1<[Case Sub team]-={"BBDC*"}>}[Exception ID])