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 , 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
4 years agoNot applicable
Why it returns the count of rows?