Bar Chart Calculation Conditon in Combination with Wildmatch Field

[Sebas]

Hi all,

I have a bar chart which shows the sales statistics of different persons. The chart shows all the sales persons from different shops. I need to limit the available data to only the shop that I'm supplying the stream. So i put in a calculation condition 

GetFieldSelections(Shop) ='Cologne' 

in order to only show this one shop. This works fine but i also need to limit the selection of the Filter pane "Shop" for other statistics. As soon as i do that with this funtion

=if(wildmatch(Shop,'*Cologne*'),Shop)

the chart will not calculate because the condition is not fulfilled, even though the right selection is made in the filter pane.

Does anyone have an answer to why it is not working?

Thank You in Advance

Sebastian

[Yoshidaqlik]

Hello, how are you, Sebastian?

Are seller and store tables not linked?

theoretically when you filter the store should already appear only sellers of the store corresponding to the filter

As for the function, try to put a conditional comparison, I think it should solve

=if(wildmatch(Shop,'*Cologne*')>0,Shop)

Regards

[sunny_talwar]

May be try this

=If(WildMatch(GetFieldSelections(Shop, '|'), '*Cologne*'), Shop)

Or just this 

WildMatch(GetFieldSelections(Shop, '|'), '*Cologne*')

[Sebas]

Hi,

thanks for your replies!

Yes seller and shop are linked, but if no selection is made, everyone can see all the sellers from every shop and i need to avoid that.

Anyway I found another solution in the meanwhile using the following function in the 'sales' field:

Sum({<Shop={'Cologne'}>}[sales])

Thanks for your help!