Dynamic Parameter with values based on selected value through the slicers

[anmoltripathi5]

Please help me with the below problem.

I have products in my data like product1, product2, product3 and so on.

These products have presence in different countries. For example product1 is present in USA, India, china whereas product2 is present in Russia, India and USA.

I created a dashboard where I have a slicer(single select) of the product by which I can select any single product at a time. 

I want to create a dynamic parameter in which I get the list of all distinct countries except the countries present in selected product through the slicer.

For example when I select product 2 then parameter should contain all districts countries except Russia India and USA.

If I select product 1 that parameter should change dynamically and should contain all countries except USA, India, china.

Thanks in advance 

@Anonymous , @Anonymous 

[shafiz_p]

Hi @anmoltripathi5 ,
It is better to provide representative data and expected output t get exact soluion.

However, as I understand that you want a solution to list distinct countries which are not in the selected product. If this is the case then you need a disconnected table of distinct product which will be used in slicer.

See example date based on your discription. Data source image:

Created disconnected table of distinct product for to use in slicer field, see image:

No relationship between the table.

Placed the product from Distinct Product table in slicer. See image:

Now create a measure to list all the distinct country separated by comma which are not the country of selected product.

Try this code to create measure:

DistinctCountriesNotInSelectedProduct = 
VAR SelectedProduct = SELECTEDVALUE('Distinct Product'[Product])
VAR AllCountries = DISTINCT('DataSource'[Country])
VAR CountriesInSelectedProduct = CALCULATETABLE(
    DISTINCT('DataSource'[Country]),
    'DataSource'[Product] = SelectedProduct
)
RETURN
CONCATENATEX(
    EXCEPT(AllCountries, CountriesInSelectedProduct),
    [Country],
    ", "
)

Place this in card and you are done. See output image:
When no selection is made:

When selected Product 1:

When selected Product 2:

Hope this helps!!

If this solved your problem, please accept it as a solution and a kudos!!

Best Regards,
Shahariar Hafiz

[danextian]

Hi @anmoltripathi5 

If by a dynamic parameter you mean to create a list of countries that are not present in selected products' countries, the you need to duplicate your product table and use a measure to filter the visible countries in a table visual.

If you're referring to the field parameter, the fields you added to it are what you get and won't change based on  slicer selection. The field parameter feature creates a calculated table and calculated tables are updated only if the underlying data has been refreshed or the formula has been in any way modified. Please see attached sample pbix.