Reputation: 125
I have measure that store the Slicer selected value. now I want to store measure value in new table but not getting success. Please help here.
Also i want to know if there is a way to store slicer selected value in table directly.
below syntax i used to store slicer selected value in measure Slicer_Value = selectedvalue(column)
Regards, SK
Upvotes: 0
Views: 1090
Reputation: 40244
You cannot store a slicer selection in one of your model tables (either in a new calculated table or a calculated column on an existing table) since these are only calculated when your data is loaded or refreshed rather than every time you make a slicer selection.
However, it's highly likely that there is another way to do whatever it is you are ultimately trying to achieve by another method.
Upvotes: 0