Conditional expression on a chart

[brunolelli87]

Dears,

I have a chart with

Dimensions = Stickers and,
Expression =num(avg([P/L]), '#.##0,00;-#.##0,00')

So, the user can select some Stickers, as dimensions, and I would like that, if just one Sticker is selected, the system should show 2 bars, the one related to the expression, and another one with the following formula: "=num(avg({<Sticker,SubsetorEmpresa=p(SubsetorEmpresa)>}[P/L]),'#.##0,00;-#.##0,00')"

I'm trying to use the conditional function with the following formula: 
"= IF(GetSelectedCount(Sticker) > 0, 1, 0)", but it's not working properly..

How can I do it?

Thanks

Bruno Lelli

[Lisa_P]

On the second expression, use the condition:
= IF(GetSelectedCount(Sticker) > 0)

[brunolelli87]

It's not working

What do you mean by the second expression?

Please, check the picture...

[brunolelli87 · Accepted solution]

I found a way to solve it...

On condition field:
GetSelectedCount(Sticker) = 1

On expression field:
=num(avg(TOTAL {<Sticker,SetorEmpresa=p(SetorEmpresa)>}[P/L]),'#.##0,00;-#.##0,00')

Thanks guys!