Syntax/Function to use crossfilter

[Averin7777]

Hello, 

I need to find out, which DAX syntax and function I need to use in order tu use two connected filters. Example, When I use one filter it will influence second filter, like filter in Business - default, and in Other filter it shows me countries which are default f.i. 2 from 10, and when in Business - Other, in next shows me the rest 8?? 

Thanks a lot for help!!!

[Averin7777]

I have already created new columns for retailer like data for Amazon 1P are Default, and rest 2P and others are Rest

[Averin7777]

trying to use this syntax

IF( SELECTEDVALUE(attr_product[RETAILER FILTER], "Rest"), and here add something like ...than fct[RETAILER] shows all options but without Amazon 1P because is default. but the syntax showing me error. 

[TomasAndersson]

Hi!

It might be easier if you can share some if your data so we can help more specifically.

One possible way would be to create a new column to support this. You could for example add "Business Type" to your table with countries, and then create a relationship between the tables. For example

Country	Business Type (new)
Angola	Other
Bermuda	Other
Cameroon	Other
Denmark	Default
England	Other
France	Other
Ghana	Other
Honduras	Other
Iran	Other
Jordan	Default

This way, the "country table" would be filtered based on Business Type, allowing you to apply further filters only with countries of a specific type. 

[Averin7777]

hello, thank you sure, I have one filter here:

and second one like this 

And I would like to set up, If I click in first Default, second filter shows me only Amazon 1P as an option. 

And when I click Rest, it shows other options to choose but wtihout Amazon 1P. 

I have in data, table that contains Columns Like Amazon 1P is default, and rest are Rest. But I do not know how to connect these two filters in order to cooperate as I describe