How can I use a dax measures to ignored the current filter but only filter based on the dax measure

[mighty]

I have the following filters on the dashboard:

I have used a funnel visual below

I am struggling and trying to calculate the number of  learners who are enrolled for 2024, the column name is "Year_Enrolled" but when I use the following dax measure:

Enroled = CALCULATE (
                       DISTINCTCOUNT ( Learner[id] ), Learner[Date_Approved_Scholar_Application] <> BLANK () )

                               + CALCULATE (

                      DISTINCTCOUNT ( Learner[id] ), Learner[Date_Approved_Sibling_Application] <> BLANK () )

)

it does not allow ingore the commencement_year filter shown above, so it filtered based on the commencement_year and I want it to ignore that. Therefore I tried using the following dax measure:

Enroled =
CALCULATE (
DISTINCTCOUNT ( Learner[id] ),
Learner[Date_Approved_Scholar_Application] <> BLANK (),
FILTER ( Learner, Learner[Year_Enrolled] = 2024 )
)
+ CALCULATE (
DISTINCTCOUNT ( Learner[id] ),
Learner[Date_Approved_Sibling_Application] <> BLANK (),
FILTER ( Learner, Learner[Year_Enrolled] = 2024 )
)

But still it does not ignore the commencement_year filter, I only want the Enroled to be filtered based on the Year_Enrolled without additing Year_Enrolled filter on the dashboard. But the rest of the counts such as "Fees Paid" and "Contract Signed" to be filtered based on commecement_year filter.

[nandukrishnavs]

@mighty 

Try this 

Enroled =
CALCULATE (
    DISTINCTCOUNT ( Learner[id] ),
    Learner[Date_Approved_Scholar_Application] <> BLANK (),
    REMOVEFILTERS ( Table[commencement_year] ),
    FILTER ( Learner, Learner[Year_Enrolled] = 2024 )
)
    + CALCULATE (
        DISTINCTCOUNT ( Learner[id] ),
        Learner[Date_Approved_Sibling_Application] <> BLANK (),
        REMOVEFILTERS ( Table[commencement_year] ),
        FILTER ( Learner, Learner[Year_Enrolled] = 2024 )
    )

[mighty]

Still it is filtering the commencement_year 😥

[nandukrishnavs · Accepted solution]

@mighty  If you don't want Year_Enrolled = 2024, you can remove filter condition from the measure.

Below measure will ignore the filter applied on Table[commencement_year]

Enroled =
CALCULATE (
    DISTINCTCOUNT ( Learner[id] ),
    REMOVEFILTERS ( Table[commencement_year] ),
    Learner[Date_Approved_Scholar_Application] <> BLANK ()
)
    + CALCULATE (
        DISTINCTCOUNT ( Learner[id] ),
        REMOVEFILTERS ( Table[commencement_year] ),
        Learner[Date_Approved_Sibling_Application] <> BLANK ()
    )

OR

Enroled =
CALCULATE (
    DISTINCTCOUNT ( Learner[id] ),
    ALL ( Table[commencement_year] ),
    Learner[Date_Approved_Scholar_Application] <> BLANK ()
)
    + CALCULATE (
        DISTINCTCOUNT ( Learner[id] ),
        ALL ( Table[commencement_year] ),
        Learner[Date_Approved_Sibling_Application] <> BLANK ()
    )