Help with measure that counts rows ignoring a date slicer but also equal to a max date

[Anonymous]

Hello 

I am trying to create some visuals where my users will be able to compare the latest data to any point in time using a slicer.

I am trying to create a measure that filters to only count rows of my table that are equal to the MAX date in that table which I can do and looks like this:

Test = CALCULATE(COUNT(Data[Emp Count]),(filter(Dates,Dates[Date]=max(Data[Month]))))

This works as intended but I want to do is make it so it would be unaffected using a date slicer on my page which also uses a column from my Dates table.

Any help greatly appreciated.

thanks, 

[kentyler · Accepted solution]

Try adding and ALL() filter to your CALCULATE statement. CALCULATE is the only function that can modify the filter context created by things like slicers.

Test = CALCULATE(COUNT(Data[Emp Count]),ALL(Data),(filter(Dates,Dates[Date]=max(Data[Month]))))

I learn something every time I answer a question

I'm a personal Power BI trainer