Forum Discussion

rainchong7401's avatar
rainchong7401
Icon for Helper III rankHelper III
3 years ago
Solved

Not 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...
Need Help
  • lukiz84's avatar
    lukiz84
    3 years ago

    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)

     

v-yalanwu-msft's avatar
v-yalanwu-msft
Icon for Community Support rankCommunity Support
3 years ago

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.