Dropdown filtering in SAC

[Mohamed_Amin_Ouerfelli]

SAP Managed Tags: SAP Analytics Cloud, analytics designer

Hi community

I am new to SAC.

I want to introduce a dropdown filtering menu in my story. I succeded in populating the dropdown using these lines of code in the onInitialization() function : 

var Inspectors_list = Table_1.getDataSource().getMembers("Don_ordre.Inspecteur");

if (Inspectors_list.length > 0) 

{

for (var i=0;i<Inspectors_list.length; i++){

Dropdown_1.addItem(Inspectors_list[i].id,Inspectors_list[i].description);

}}

Then i proceeded to to adding the following lines of code in the Dropdown_1 - onSelect() :

var x = Dropdown_1.getSelectedKey();
console.log(x);
Table_1.getDataSource().setDimensionFilter("Don_ordre.Inspecteur",x);


The filter is not working correctly and i do not understand why.
There is only two values in the dropdown once selected returns values , all the others returns zero.

Also i figured if it's an issue with my model , why would two values from the dropdown filter correctly and the others won't.

Also some screenshots from the modeler