Filter All not working ?

[Anonymous]

Hi All, 

I'm trying to get YTD counts and using the logic below , however the same count is shown despite having different report filters . Any idea what Im missing ?

YTD Milestone Count = VAR startdate = DATE(YEAR(TODAY()),1,1)

var enddate = TODAY()

RETURN

CALCULATE(

COUNTROWS(fact_milestones),

FILTER(ALL(fact_milestones[milestone_date],fact_milestones[summary_milestone_type],fact_milestones[milestone_type],fact_milestones[RSfam_milestonetype]),fact_milestones[milestone_date]>= startdate

&& fact_milestones[milestone_date]<= enddate))+0

Below are the report filters that should show the counts based on the filters .TIA

[v-eqin-msft · Accepted solution]

Hi @Anonymous ,

The biggest difference between ALL and ALLSELECTED is that the ALL function ignores all filters, regardless of where they are coming from. In contrast, the ALLSELECTED function only ignores filters that are coming from the inner query.

I have created a data sample :

Please try ALLSELECTED()

YTD Milestone Count = 
VAR startdate = DATE(YEAR(TODAY()),1,1)
var enddate = TODAY()
RETURN
CALCULATE(
COUNTROWS(fact_milestones),
FILTER(ALLSELECTED(fact_milestones),[milestone_date]>= startdate&& [milestone_date]<= enddate))+0

 Output:

Here are some blogs talking about the differences , please kindly refer to:

What's the Main Difference Between ALL &amp; ALLSELECT... - Microsoft Power BI Community

The Difference Between ALL And ALLSELECTED DAX Functions In Power BI | Enterprise DNA

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[parry2k]

@Anonymous because you are using ALL  in your measure, it is removing filters on all those columns.

✨ Follow us on LinkedIn and  to our YouTube channel

Learn about conditional formatting at Microsoft Reactor

My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!