Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 ?
Solved! Go to 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.
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.
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.
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!
User | Count |
---|---|
98 | |
90 | |
83 | |
70 | |
67 |
User | Count |
---|---|
113 | |
104 | |
101 | |
73 | |
65 |