ALL filter ignoring slicer

[Ben81]

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 it just doesn't seem to work. 

My measure is this...

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

I've used these type of things before and never had the problem but for this one it just won't ignore this period slicer. 

Any ideas?

Thanks,

Ben

[PickleBear]

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 · Accepted solution]

I've managed solve the issue using ALLEXCEPT function! 

Thanks everyone,

Ben

[Ben81]

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.

[Idrissshatila]

Hello,

Try this measure

CALCULATE (

    [measure],

    DATESYTD ( 'Date'[Date] )

)

and for more info you can check SQLBI Blog https://www.sqlbi.com/blog/marco/2018/08/10/the-hidden-secrets-of-totalytd/

If I answered your question, please mark my post as solution, Appreciate your Kudos!

Follow me on Linkedin

[Ben81]

Hi mate, that doesn't do anything. The chart is still effected by whatever period you have selected on the slicer.

[Idrissshatila]

okay then try this