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 , 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