skroutela
skroutela

Reputation: 125

how to store measure value in table in Power BI?

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

Answers (1)

Alexis Olson
Alexis Olson

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

Related Questions