Slicer selection should effect only for few measures

[PowerBigginer]

I created a table visual. is it possible to effect slicer selection only for few measure not for all for instance if you see below table 

Name	Salary	Incentives
A	10000	100
B	20000	200
C	30000	300

 here If I select month in the month slicer only Incentive column should change not the salary column. Is it possible to create dax to achieve this ?

[Anonymous · Accepted solution]

Hi @PowerBigginer ,

Thanks for the reply from @manvishah17  and @samratpbi , please allow me to provide another insight: 

If you want slicer to not filter the data in the table, you can create a new table with filtered columns and don't create a relationship with the original table.

Based on your description, I created these data:

1. create the calculation table.

Table 2 =
DISTINCT('Table'[date])

2. create slicer and put the fields from the calculation table into the slicer.

3. create measure.

Measure =
CALCULATE(SUM('Table'[Incentives]),FILTER(ALL('Table'),'Table'[date] = MAX('Table 2'[date]) && 'Table'[name] = MAX('Table'[name])))

If your Current Period does not refer to this, please clarify in a follow-up reply.

Best Regards,

Clara Gong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[manvishah17]

See ideally, if any column of your table is getting filter via slicer then its corresponding values of other column in that table  also get filtered.
Now the question you want that values remain same all over table or the no of row of a column remain same even if slicer is selected.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[samratpbi]

Hi, you need to remove the filter context that is being applied by your slicer. So, if you have Month slicer, then remove filter of Month in the Salary measure using ALL function. Not sure about your calculation, but remove filter on month using like ALL(T1[month]).

Hope this helps.

If this helps to resolve your problem, then please mark it as solution provided, Thanks!