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 20...
So, what the measure will include?
By the way, countows is not defined as function in my Power BI
- amitchandak
Super User
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] )
Why it returns the count of rows?
