Sumx and summarize with filter

[o59393]

Hi all

I have the following dax

How can I make row 9 equals to a certain text of the column "L1.4 - reffilability" ?

In this case that column has 5 different values:

[ L1.4 - Refillability ]

Non-Refillable Personal

Non-Refillable Family

Refillable Family

Refillable Personal

Fountain

How can I make it equal to Non-Refillable Personal?

I tried:

Merge1[[ L1.4 - Refillability ]]] = "Non-Refillable Personal"

or

Merge1[[ L1.4 - Refillability ]]] IN  {"Non-Refillable Personal"}

But it didnt work.

Thanks!

[mahoneypat · Accepted solution]

In your SUMMARIZE, replace the initial MERGE1 with

FILTER(Merge1, Merge1[[ L1.4 - Refillability ]]] = "Non-Refillable Personal")

Regards,

Pat