topic How can I use a dax measures to ignored the current filter but only filter based on the dax measure in DAX Commands and Tips

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

mighty — Thu, 10 Aug 2023 09:50:52 GMT

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.

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

nandukrishnavs — Thu, 10 Aug 2023 09:57:39 GMT

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 ) )

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

mighty — Thu, 10 Aug 2023 10:38:59 GMT

Still it is filtering the commencement_year 😥

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

nandukrishnavs — Thu, 10 Aug 2023 10:46:35 GMT

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 () )

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 () )