Identify order in which Field parameters items were selected?

Question

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 depending if I go forecast -> budget or budget -> forecast.

When I add field parameter items to matrix as columns (selecting them), columns are added in order that I clicked individual field parameters. Is it possible to identify using DAX which was selected first and which was second? That way I could calculated variance mentioe

ondrej_bartak · Answer

Thanks, but that defines order/grouping, right? What I need is know what was the click order, i.e. if I clicked/selected month first, then quarter in your example, than is should be month = 1 and quarter = 2.

idrissshatila · Answer

Hello Ondrej_Bartak ,&nbsp;Yes you could add the number of which one is displaced first as the below exampleDate Parameter = {&nbsp; &nbsp; ("Year", NAMEOF('Date'[Year]), 0),&nbsp; &nbsp; ("Quarter", NAMEOF('Date'[Quarter]), 1),&nbsp; &nbsp; ("Month", NAMEOF('Date'[Month]), 2),&nbsp; &nbsp; ("Day", NAMEOF('Date'[Day of Week]), 3)}&nbsp;If I answered your question, please mark my post as solution, Appreciate your Kudos 👍&nbsp;Follow me on Linkedin

testprimest · Answer

looking for the same solution

stenpede · Answer

Hi&nbsp;@Ondrej_Bartak,&nbsp;testprimest&nbsp;, 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= {&nbsp; &nbsp; ("Param1", NAMEOF('MyTable'[dim1]), 0),&nbsp; &nbsp; ("Param2", NAMEOF('MyTable'[dim2]), 1),&nbsp; &nbsp; ("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 =&nbsp; &nbsp; SELECTCOLUMNS (&nbsp; &nbsp; &nbsp; &nbsp; SUMMARIZE ( 'params', 'params'[parameter] ),&nbsp; &nbsp; &nbsp; &nbsp; "ParamValue", 'params'[parameter]&nbsp; &nbsp; )RETURN CONCATENATEX (&nbsp; &nbsp; ADDCOLUMNS (&nbsp; &nbsp; &nbsp; &nbsp; VALUES('params'[parameter]), &nbsp; &nbsp; &nbsp; &nbsp; "SelectedOrder", RANKX(__SelectedValue, 'params'[parameter], , ASC)&nbsp; &nbsp; ),&nbsp; &nbsp; ''params'[parameter],&nbsp; &nbsp; ", ",&nbsp; &nbsp; [SelectedOrder])Getting a list of selected parameters, in the order stated in the parameter table, can be done like this:Measure_selected_params =VAR __SelectedValue =&nbsp; &nbsp; SELECTCOLUMNS (&nbsp; &nbsp; &nbsp; &nbsp; SUMMARIZE ('params', 'params'[parameter], 'params'[Parameter Fields]),&nbsp; &nbsp; &nbsp; 'params'[parameter]&nbsp; &nbsp; )RETURN CONCATENATEX ( __SelectedValue, 'params'[parameter], ", " )

ppezzuto68 · Answer

Still waiting for solution. I want to make the right levels subtotals in a matrix And I've multiple selection as SEX,AGE,TYPE and people can select this to have rows grouping dynamic and I must calculate totals about every previous level. But I can't get the right selection order. Anyone found the solution ?

Forum Discussion

Identify order in which Field parameters items were selected?

8 Replies

Related content

Parameter selection for charts

Sum dynamic parameter fields multiple selected parameter

Parameter: Selected Value doesn’t updated

Parameter: Fields selected value

Select all parameter