MDX : Removing All from parameter list in SSRS

Problem Domain : Remove All option from your parameter drop down list.

Workaround : To remove All option from your parameter drop down list, just right click   

on Datasets and click on ‘Show Hidden Datasets’.

It will show you different datasets for different parameter.(Refer below screenshot)

There are following two ways to remove All from selection-

1.     First one requires query modification-

        Double click on desired dataset and open it into query designer mode

        then Change ALLMEMBERS to CHILDREN as highlighted below.

2.    Second solution requires adding  filter using the filter dataset method-
       right click on desired  dataset (use above technique to unhide the hidden                          datasets),and then select Query Properties.

       Within the Dataset Properties Window, click on the Filter Option,eXclude All by                using a filter of ParameterLevel > 0 as displayed below.

Save and run the report ,The parameter will not show All option. 

Likewise you can remove unnecessary options available in parameter dropdown list

Like UNKNOWN , Blank and also any particular value.