Forum Discussion
Helper IALL 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 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
I've managed solve the issue using ALLEXCEPT function!
Thanks everyone,
Ben
6 Replies
- Idrissshatila
Super User
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!
Ben81Hi 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
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
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.
