Excluding bar chart from selections

[pauldamen]

Hi,

I have a stacked bar chart which has an expression which looks like this:

count ({<NPS = {'1'}>}[NPS])

Now this is a total bar chart used as an benchmark and should not change with the selection (the same bar chart is next to it which does change so you always have the comparison). Now my questions is: how can I prevent the bar chart to change with the selections?

Thanks for your help!

Regards,

Paul

[#2 · Accepted solution]

Hi,

try using

count ({1<NPS = {'1'}>}[NPS])

Regards

Przemek

[CELAMBARASAN]

Hi,

     Using 1 will excludes the all field selections.

     =count ({1<NPS = {'1'}>}[NPS])

Celambarasan

[nilesh_gangurde]

Hey ,

Try this one:

=count({<Field_name1 =,Field_name2,NPS ={'1'} >}[NPS])

Where Field_name1 and Field_name2 is the name of the fields which u want to avoid the selections.

Hope this will help you.

Regards,

Nilesh Gangurde

[jagan]

Hi,

For excluding all the selections use this expression

=count ({1<NPS = {'1'}>}[NPS])

For excluding particular expressions, specify fields to exclude with =

=count ({ <FieldName1=, FieldName=2, NPS = {'1'}>}[NPS])

Hope this helps you.

Regards,

Jagan.

[sridhar240784]

Hi,

Additional info, if you want to exclude all the fields except FieldName3, FieldName4. You may try below code.

Sum ({<NPS = {'1'},$(=Concat(if(Not WildMatch($Field, 'FieldName3',''FieldName4'','NPS'),$Field),'=,')&'=')>} NPS)

Attached is an example.

-Sridhar

[pauldamen]

Thanks a lot to all of you! It works!