Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
try using
count ({1<NPS = {'1'}>}[NPS])
Regards
Przemek
Hi,
Using 1 will excludes the all field selections.
=count ({1<NPS = {'1'}>}[NPS])
Celambarasan
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
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.
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
Thanks a lot to all of you! It works!