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....
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

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