Apply filter for selected column and not the whole table

[Juleeees]

Hi, 

I want my filter to change only certain columns. In my example table, the ABC analysis should always depend on the total turnover and not change when filtering. The other column, Spend, is allowed to change or filter.

Company	Spend	ABC Analysis
Microsoft	100.000	A
Google	50.000	B

A and B are quantiles of total turnover. If we change the slicer to "Microsoft", the ABC Analysis should be from the total spend and not from the filtered total spend. 

Thanks

[v-shex-msft · Accepted solution]

Hi @Juleeees,

The default filter features not able to achieve your requirement.

I'd like to suggest you create an unconnected table with these field values and use it as source filter/slicer. Then you can write formula to interact with these selections in correspond calculations.

Regards,

Xiaoxin Sheng