Task:
Is there a way to create a calculated field that tracks the size of a parameter list?
Details:
I currently have a parameter of data type String and values Multiple values.
This parameter can be altered by the user using a filter which is a multiselect list of a number of strings.
I would like to create a calculated field that dynamically returns the number of selected items in the parameter filter (or in other words the size of the parameter list).
I have limited experience with calculated fields and couldnt find existing online resources that would help with this task.
Any solutions or alternative ideas are welcome.
do you use a dataset field (e.g. ID) as values?
you could create a calculated field to count the IDs.
Create a visual with that field and set a filter with your paramater.
The filter does use a dataset column as the values and is called store.
But im not following how “Create a visual with that field and set a filter with your paramater.” helps, could you elaborate?
Note that the calculated field should count the number of selected items in the parameter filter and not just the total number of unique items in the store column.