Forum Discussion

danextian's avatar
danextian
Icon for Super User rankSuper User
9 years ago

Function ALL not working when trying to remove filter from a measure

Hi All,

 

I have a page filter for rolling months showing just the past 13 months. However, I want a measure to show all rows and not be affected by the page filter. I use ALL but  it  is not working.

 

My measure is this 

Amount (All) = SUMX(ALL('Calendar'[Rolling Months]),[MEASURE])

 

The measure doesn't show values past 13 months.

 

 

 

 

Need Help

5 Replies

  • spuder's avatar
    spuder
    Icon for Resolver IV rankResolver IV
    9 years ago

    Hi danextian

     

    I don't think that will work. Visual, Page and Report Level Filters can't be eleminated by DAX.

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    danextian

     

    Hi,

     

    ALL will work. You should try Calculate like this if you have a filter on Rolling Months.

     

    Amount(all) =
CALCULATE ( [MEASURE], ALL ( 'calendar'[Rolling Months] ) )

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    Best Regards!

    Dale Cui

    • danextian's avatar
      danextian
      Icon for Super User rankSuper User
      9 years ago

      Hi v-jiascu-msft

       

      I tried  this but it did not work. My page filter is for rolling 13 months.  Jan-Mar last year still showing blank values.

       

    • danextian's avatar
      danextian
      Icon for Super User rankSuper User
      9 years ago

      I tried using all(table). The values in the matrix  updated with the value of all rows in the table for that measure but Jan-Mar are still blank.

       

      Could you give me a copy of your pbix? I might be doing it wrong.

      • v-jiascu-msft's avatar
        v-jiascu-msft
        Icon for Microsoft Employee rankMicrosoft Employee
        9 years ago

        danextian

         

        Hi,

         

        I just tested it with the formula. Nothing special. Could you please post formula here? You can use dummy names. Another possibility is that you have chosen the wrong column from a different table, which filtered the Jan-Mar. Please check it out.

         

        Best Regards!

        Dale.