How to remove page filter using dax when tables are linked

[Anonymous]

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!

[MFelix]

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.