Forum Discussion

RobertaCC's avatar
RobertaCC
Frequent Visitor
2 years ago

input values for a new calculated table

Hi everybody! I have built the script below and it works. What I need is to turn the var "range" into a variable that users select.   I tried building a parameter and even another query with all th...
" Slicer"
"Dynamic Slicer"
"FILTER"
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi RobertaCC 

 

Thanks to AmiraBedh for the prompt reply.

 

I have another idea though. If your purpose is to create a calculated table and let report users can switch the value provided for the variable "range" via perhaps a slicer, this is not possible currently. A calculated table is evaluated when it's created or refreshed, make it looks "static". It cannot be affected dynamically by a slicer or filter from the report, so it cannot be affected by users. That's why you find the function SELECTEDVALUE always gives you a blank result as it doesn't get a value selected from a slicer/filter but gets the altervative "blank" value from the table which has all possible values. 

 

Only measures can be affected by filters/slicers which can be used by report users. 

 

Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!