Forum Discussion
Anonymous
4 years agoNot applicable
Create a new calculated table using filtering based on a what-if parameter does not work
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 20...
amitchandak
Super User
4 years agoAnonymous , 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 )