Create a new calculated table using filtering based on a what-if parameter does not work

[Anonymous]

I have the following table and i want to filter one of two rows based on a what-if parameter.

Threshold Lower	Threshold Upper	Intercept	Gradient
0	100000	0.05	2
100000	200000	0.1	4

I have tried to create a new calculated table using the following DAX formula:

Table_New = FILTER('Table', AND('Table'[Threshold Upper] >= 'Parameter'[Parameter Value],'Table'[Threshold Lower] <= 'Parameter'[Parameter Value]) )

It does work but when i change the value of the parameter the table does not updated. 

How I can fix this?

[Anonymous]

So, what the measure will include?

By the way, countows is not defined as function in my Power BI

[amitchandak]

@Anonymous , Sorry typo, countrows, use can use countx, sumx, minx, maxx and then use this var table

Measure =

var _Table_New = FILTER('Table', AND('Table'[Threshold Upper] >= 'Parameter'[Parameter Value],'Table'[Threshold Lower] <= 'Parameter'[Parameter Value]) )

return

countrows(_Table_New )

or

return

countX(_Table_New,_Table_New[Value]  )

[Anonymous]

Why it returns the count of rows?

[amitchandak]

@Anonymous , You can not use any slicer or what-if parameter value in the creation of a calculated table.

You can create a table using that as var in measure. Each measure that need this table, you need to have that

Measure =

var _Table_New = FILTER('Table', AND('Table'[Threshold Upper] >= 'Parameter'[Parameter Value],'Table'[Threshold Lower] <= 'Parameter'[Parameter Value]) )

return

countows(_Table_New )