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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.