Forum Discussion
How to create custom filter
Hello. I have two tables. First has product id and appropriate value, while the second has countries which have made the trade. So if I select one product the second table shows countries which have ...
Anonymous Hi in this case you will need to create a calculated table like belwo for two slicer values
Step 1:
Data_Type_Selected = {
(1,">10 Mio"),
(2,"<10 mio")
}
Create your measure that will filter values basis your selection
Step 2:
Data_type_Filter_value =
IF(HASONEFILTER(Data_Type_Selected[Selection]),
SWITCH(SELECTEDVALUE(Data_Type_Selected[Selection]),
">10 mio", SUM(product value),
"<10 mio", SUM(product value),
),
BLANK()
)
In case you are not able to perform above steps, please share your sample data in text format.