Forum Discussion
Syntax/Function to use crossfilter
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!!!
4 Replies
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.
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
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.I have already created new columns for retailer like data for Amazon 1P are Default, and rest 2P and others are Rest
