Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
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.
think, it should be minus followed by the equal:
Count({<[Case Sub Team] -= {'BBDC*'}>}[Exception ID])
may be this?
= count(IF( Not Wildmatch([Case Sub team], 'BBDC*')>0, [Exception ID])
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
May be try
count({1<[Case Sub team]-={"BBDC*"}>}[Exception ID])