Background total showing on bar chart

[richard_wylde]

Hello,

I have a bar chart where the measure is chosen by the user from a list of values, using the following :-

Measure =IF([Dummy]="TAX",SUM(Query1[TAX]),    IF([Dummy]="GROSS",SUM(Query1[Gross]),       SUM(Query1[NETT(£)])                       )

However, in the background it shows the total of all the measures. So in the example below the measure chosen is TAX = 50,131.27, however in the background it is also showing Measure = 582,334.27

Is there any way to get rid of  this ?

[v-chuncz-msft · Accepted solution]

@richard_wylde ,

You may change the Visual interactions from cross-highlight to cross-filter.