Forum Discussion

o59393's avatar
o59393
Icon for Post Prodigy rankPost Prodigy
5 years ago
Solved

Sumx and summarize with filter

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!
 
Need Help
Show and Tell
  • mahoneypat's avatar
    mahoneypat
    5 years ago

    In your SUMMARIZE, replace the initial MERGE1 with

     

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

     

    Regards,

    Pat

1 Reply

  • mahoneypat's avatar
    mahoneypat
    Icon for Microsoft Employee rankMicrosoft Employee
    5 years ago

    In your SUMMARIZE, replace the initial MERGE1 with

     

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

     

    Regards,

    Pat