Forum Discussion
Identify order in which Field parameters items were selected?
I have a waterfall chart walking through from actual or forecast to budget - selection being done using field parameters. There is also variance drillthrough available. That variance however varies d...
Hi @Ondrej_Bartak, testprimest , did you find any solution for this? I am also looking for a solution in the same context. But in my case I would like to have a concatenated string of the selected values in a parameter.
Let say a have a parameter table, params, like this:
parameter= {
("Param1", NAMEOF('MyTable'[dim1]), 0),
("Param2", NAMEOF('MyTable'[dim2]), 1),
("Param3", NAMEOF('MyTable'[dim3]), 3)
}
If I selected in the follow order: first Param3, secondly Param1 but not selecting Param2, I would like to get a string back that is "Param3, Param1"
I am elaborating around something like the code below, but can not get it working as expected, I am getting the following error
"Column [parameter] is part of a composite key, but not all columns of the composite key are included in the expression or its dependent expression."
Measure_selected_params_ordered =
VAR __SelectedValue =
SELECTCOLUMNS (
SUMMARIZE ( 'params', 'params'[parameter] ),
"ParamValue", 'params'[parameter]
)
RETURN CONCATENATEX (
ADDCOLUMNS (
VALUES('params'[parameter]),
"SelectedOrder", RANKX(__SelectedValue, 'params'[parameter], , ASC)
),
''params'[parameter],
", ",
[SelectedOrder]
)
Getting a list of selected parameters, in the order stated in the parameter table, can be done like this:
Getting a list of selected parameters, in the order stated in the parameter table, can be done like this:
Measure_selected_params =
VAR __SelectedValue =
SELECTCOLUMNS (
SUMMARIZE ('params', 'params'[parameter], 'params'[Parameter Fields]),
'params'[parameter]
)
RETURN CONCATENATEX ( __SelectedValue, 'params'[parameter], ", " )