Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Ben81
Helper I
Helper I

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 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

1 ACCEPTED SOLUTION

I've managed solve the issue using ALLEXCEPT function! 

 

Thanks everyone,

Ben

View solution in original post

6 REPLIES 6
PickleBear
New Member

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.

I've managed solve the issue using ALLEXCEPT function! 

 

Thanks everyone,

Ben

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
Super User
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!

Follow me on Linkedin



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




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 Screenshot 2022-12-20 144729.png



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors