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 also exported the selected product. Now I want a filter that shows values greater than which is input by the user. for example, if the user wants to see total values for each product greater than 10 mln $ so minimum value in the first table must be 10. How can I create that type of filter?
4 Replies
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 selectionStep 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.Anonymous , Assumed you have used a what if parameter, then you can create a measure like this
measure =
var _max = maxx(allselected(slicer),slicer[paramvalue]) //what if
return
Sumx(Values(Table[product]), if(Sum(Table[Value])>_max,Table[Value],blank()))Link -https://docs.microsoft.com/en-us/power-bi/desktop-what-if
hi Anonymous
For your case, you need to create a parameter for a slicer, you could just use what if parameter to get it.
https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-what-if
Then use this parameter measure as a conditional as below:
Measure = SUMX(FILTER(VALUES('Table'[product id]),[Total values]>[Parameter Value]),[Total values])If you still have problem, please share your sample pbix file and your expected output.
Regards,
Lin
