Forum Discussion
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 ...
I've managed solve the issue using ALLEXCEPT function!
Thanks everyone,
Ben
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!
Hi mate, that doesn't do anything. The chart is still effected by whatever period you have selected on the slicer.
okay then try this