Need the count of ID for a particular date. The count should not be affected by any filter

[Mamta123]

My data has the following columns: ID, Joining Date and Last date

I need to count the no. of attritions,  I have to use the count the no of Ids considering the Max Last Date of the data.

It should not be affected by joining date filter.

[Taoufiq_Zarra]

can you share a sample data

[Mamta123]

This is sample data

Id	Joining Date	Last Date
1	1/12/2016	9/12/2019
13	2/3/2015	9/13/2018
12	6/14/2017	9/14/2019
2	1/15/2016	9/14/2019
3	5/16/2016	9/14/2019
14	7/17/2016	9/12/2019
5	9/1/2018	9/12/2019
6	1/19/2018	9/13/2018

I need to get the count of attrition on the last date of the month but the count should not show any effect of joining filter

[Taoufiq_Zarra]

can you also give the output you want on this sample data

[Death4Free]

If I understand correctly, you can use measure Aggr(Nodistinct Count({1}Id), [Last Date])