Problem on a custom column

[gianmarco]

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
Pagato	Pagato
Non Pagato	Non Pagato

What I want to achieve though is the following table:

ValueStatoPagamento

	Pagato
Pagato	Pagato
Non Pagato	Non Pagato

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

gianmarco 

[Anonymous]

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]

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