Forum Discussion
Solved
Dynamic Table based on Parameter
Hi I have created a parameter which will select a value between 1m - 100m I then have two measures Lowerbound and Upperbound. I then want to use this range to filter a table Is this possi...
Fali324 , Hope you created numeric parameter
then you will two measure
Min = minx(allselected(param), Param[Value])max = maxx(allselected(param), Param[Value])
Use in measure =
Countrows(filter(Table, Table[Value] >= min && Table[Value] <= Max ) )
https://docs.microsoft.com/en-us/power-bi/desktop-what-if
yes its a numerical parm
I've created the measures you've mentioned above. how do I now filter the table?
Fali324 , You can filter calculated tables. You can only filter measures. Like one I have give in example
Other examples are
TOPN with Numeric Parameter -https://youtu.be/cN8AO3_vmlY?t=26448