Forum Discussion

gianmarco's avatar
gianmarco
Helper IV
3 years ago

Problem on a custom column

Dear All,
I have created the follow custom column:
 
StatoPagamento_SCEN =
var _a = FILTER(SUMMARIZE(Cashflow,Cashflow[StatoPagamento]),Cashflow[StatoPagamento]<>"")
var _b = CROSSJOIN({""},_a)
var _c = ADDCOLUMNS(_a,"Value",Cashflow[StatoPagamento])
return UNION(_b,_c)
 
which returns the following table:
ValueStatoPagamento
 Pagato
 Non Pagato
PagatoPagato
Non PagatoNon Pagato

 

What I want to achieve though is the following table:

ValueStatoPagamento

 Pagato
PagatoPagato
Non PagatoNon Pagato

 

 

Do you have any suggestion on I shall modify my custom column?
Thank you a lot

gianmarco 

 
Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi gianmarco ,

    In order to better understand your demands and give the right solution, could you please provide some more specific information? such as your desensitized example data and a screenshot of your desired results?

    Thanks for your efforts & time in advance.

     

    Best regards,
    Community Support Team_Binbin Yu

    • gianmarco's avatar
      gianmarco
      Helper IV
      3 years ago

      Hi Anonymous v-bin,

       

      I can slice a table for the following row values:

      1) null

      2) x

      3) z

       

      What I want to achieve is a slicer where I can filter for the following options:

      1) x & null

      2) z

       

      In other words, you can slice for x and z only but when you slice for x you slice for null as well.

       

      Thank you very much

      gianmarco