Forum Discussion
Dynamic Table based on Parameter
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
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
