Not able to bring the column

[rainchong7401]

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 table:
1. Accountnum column
2. Ranked column (I only want RANKED = 1, do not want 2 in the new column.)
How come my ranked column formula is wrong? Ive no idea now
HELP!

[v-yalanwu-msft]

Hi, @rainchong7401 ;

You could Try it.

Newtable =
SUMMARIZE (
    FILTER ( CUSTTRANSVIEW, CUSTTRANSVIEW[RANKED] = 1 ),
    CUSTTRANSVIEW[ACCOUNTNUM],
    CUSTTRANSVIEW[RANKED]
)

 
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lukiz84 · Accepted solution]

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)