Forum Discussion
CALCULATETABLE on ALL(Table) not filtered
- 8 years ago
The filter portion of calculatetable always gets applied first, then the first parameter. It is not important if the first parameter is a variable or a native formula inside calculatetable in this case. You are first applying a filter and then removing it with all.
Maybe this
calculatetable(mytable,filter(all(mytable),mytable[mycolumn]=“myvalue”))
- 8 years ago
TL5866 wrote:Thanks. I was expecting that.
Then how would you suggest to do something like this, which is not supported by FILTER ?
MyFilteredTable = FILTER(ALL(MyTable), VALUES(MyColumn))
MyFilteredTable = calculatetable(mytable,ALL(MyTable), VALUES(MyColumn))
TL5866 wrote:Thanks. I was expecting that.
Then how would you suggest to do something like this, which is not supported by FILTER ?
MyFilteredTable = FILTER(ALL(MyTable), VALUES(MyColumn))
MyFilteredTable = calculatetable(mytable,ALL(MyTable), VALUES(MyColumn))
Aaah, right...
Thanks !!