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

[danextian]

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.

[v-jiascu-msft]

@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]

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]

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

[danextian]

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.

[spuder]

Hi @danextian

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