Forum Discussion

Ben81's avatar
Ben81
Icon for Helper I rankHelper I
3 years ago
Solved

ALL filter ignoring slicer

Hi,   I have a simple YTD chart with a measure in the value field but it's being impacted by a period slicer that I have on a centralised slicer page. I have tried using the ALL flter function but ...
Need Help
  • Ben81's avatar
    Ben81
    3 years ago

    I've managed solve the issue using ALLEXCEPT function! 

     

    Thanks everyone,

    Ben

PickleBear's avatar
PickleBear
New Member
3 years ago

Is your period slicer created from a different table to the one you are putting in the All function? Is so you'll need to switch to refering to the column you are using in your slicer.

Ben81's avatar
Ben81
Icon for Helper I rankHelper I
3 years ago

Hi, No the period slicer is in my date table and is also the same one I'm referring to in my ALL function. The only thing I can assume is causing the issue is that the measure I'm using has some dax within it that does some filters on other date fields. 

So it's like 
Measure = Calculate( SUM('Table2'[COST]),'Date'[WeekEndDate] < today()-1)

Then I have another measure which is causing the issue...

YTD Chart = CALCULATE( [MEASURE1], ALL(Period) )

I haven't tried amending the measure 1 because it is used else where within the report that needs to work off the period slicer, so I created the YTD chart measure to work seperate and ignore the periods.

 

Hope that makes sense.