Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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!
Need Help

1 Reply

  • MFelix's avatar
    MFelix
    Icon for Super User rankSuper User
    6 years ago

    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.