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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

How to remove page filter using dax when tables are linked

I have a dax measure where I have a page filter with 'Calendar'[FiscalYear] = FY20, and I want the measure below to include every fiscal (not just FY20):

 

Measure = 

CALCULATE(
COUNT(Dim_Master[Days overdue Ongoing > 6 months]),
FILTER(Dim_Master,
[Status] = "Completed" &&
[Assessment Type] = "Initial"
),
ALL(Calendar[FiscalYear])
 
Right now the results is still filtered with FY20.  'Dim_Master' & 'Calendar' has a one-to-many relationship. 
 
Looks like ALL(Callendar[FiscalYear]) doesn't work!
1 REPLY 1
MFelix
Super User
Super User

Hi @Anonymous ,

 

I believe that you need to change the place where the all is afectting the context something like this:

 

 

Measure =
CALCULATE (
    COUNT ( Dim_Master[Days overdue Ongoing > 6 months] ),
    FILTER (
        Dim_Master,
        [Status] = "Completed"
            && [Assessment Type] = "Initial"
            && ALL ( Calendar[FiscalYear] )
    )
)

 

 

Be aware that I'm making this from head may not work correctly.

 

Can you share a simple data sample if it does not work.


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

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