Forum Discussion

Ben81's avatar
Ben81
Helper 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
    Helper I
    3 years ago

    I've managed solve the issue using ALLEXCEPT function! 

     

    Thanks everyone,

    Ben

  • Ben81's avatar
    Ben81
    Helper 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.