Forum Discussion
rainchong7401
Helper III
Helper IIINot able to bring the column
Hi Friends, I have a table (Custtransview), which it has a column call "RANKED". But I'm trying to create a new table which the table I want it only contains 2 columns. Expected output: New tab...
Hi,
it doesn't work because you have to add RANKED as a normal column and then use the filter.
In general it's better to use SUMMARIZECOLUMNS.
SUMMARIZECOLUMNS(CUSTTRANSVIEW[ACCOUNTNUM], CUSTTRANSVIEW[RANKED], FILTER(CUSTTRANSVIEW, CUSTTRANSVIEW[RANKED] = 1))(because with "RANKED" and then FILTER(...) you use the expression parameter which expects a single value, you return a whole table/column with FILTER instead, that doesn't work)
lukiz84
Memorable Member
Memorable MemberHi,
it doesn't work because you have to add RANKED as a normal column and then use the filter.
In general it's better to use SUMMARIZECOLUMNS.
SUMMARIZECOLUMNS(CUSTTRANSVIEW[ACCOUNTNUM], CUSTTRANSVIEW[RANKED], FILTER(CUSTTRANSVIEW, CUSTTRANSVIEW[RANKED] = 1))
(because with "RANKED" and then FILTER(...) you use the expression parameter which expects a single value, you return a whole table/column with FILTER instead, that doesn't work)