Forum Discussion
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 | 200000 | 0.1 | 4
|
I have tried to create a new calculated table using the following DAX formula:
4 Replies
- amitchandak
Super User
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 )
- 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] )
