Exclude with IF in SUM expression Set-Analysis

[Anonymous]

Hi All,

let's assume I have the following categories and the measure Nett Amount:

Category	Subcategory
A	1
	2
	3
B
C
D

As measure, I want to use the SUM of sales of all the categories: SUM([Nett Amount])

To get an accurate overview of the sales, I want the SUM Nett Amount of all the categories without subcategory A2.

So there is one field that has to be excluded.

I tried such an expression like: SUM((IF(Not match(Subcategory,2)Subcategory))[Nett Amount]), but that didn't work.

How do I write such an expression?

Thanks a lot!

Mike

[ogster1974]

Another example of the solution including a bookmark option if you want to keep C in your charts and just exclude in particular circumstances.

[Anonymous]

Yeah thanks a lot Sunny! When having a look at your testfile, I realised I had to add the expression to both of my measures in my scatter plot.. That was pretty dumb, bt it works exactly as I wanted now:)

[Anonymous]

Thanks for your reply Andy! I was familiar with the bookmark, but that is indeed a good solution if you want to be able to switch between the two options:)