WHERE condition in chart calculated dimension

[matthewp]

i have a chart with a calculated dimension

it contains 4 possible values A, B, C, or D

however in my bar chart i only want it to contain B and C

i tried

=MATCH(CATEGORY, 'B','C',)

but this just numbered them

[Anonymous]

try like this?

if(Category='B' or Category='C', Category)

And Tick Suppress with Null Values

[Kushal_Chawda · Accepted solution]

You are missing if condition. try like this

if(MATCH(CATEGORY, 'B','C'),CATEGORY)

[hic]

I would use Set Analysis in the measure, e.g.

  Sum( {$<Category={B,C}>} Amount )

instead of

  Sum( Amount )

See A Primer on Set Analysis

HIC