Embed Filter into Chart

[JamesR]

I'm trying to embed filters into bar charts and I can't seem to figure out which syntax is will work for this. It seems a fairly easy task.

Trying to show 2, side by side bar charts one showing open sales pipeline, and one showing a closed won status.

For both charts, the Dim is Region, and the Measure is TotalPrice.

I have tried so far based on searching:

Sum(if(StageName='Closed Won', TotalPrice))

If(StageName='Closed Won', Sum(TotalPrice))

The first option returns everything in the table, so its' not checking the If correctly.

The second one returns nothing at all.

Maybe I'm trying to over-simplify this.

[Lisa_P]

We can filter our data using Set Analysis. For your scenario, the Measures will be:
Sales Pipeline
Sum({<StageName=-{'Closed Won'}>}TotalPrice)
Closed Won
Sum({<StageName={'Closed Won'}>}TotalPrice)

[JamesR]

Thank you! I will give that a try.