Count IDs with a date range slicer having met a condition

[syasmin25]

Hello, 

I am trying to count number of managers that have been using an extra printer a date slicer. The Enter Date and Leave Date columns are from when they started this fiscal year. Also, if the leave date shows blank then it shows today. I have a seperate Date table that has inactive relationships with the Enter Date and Leave Date. How would I be calculating the number of employees that are using an extra printer with a date slicer?

ID	Printer	Enter Date	Leave Date
204	Y	6/30/20	7/16/20
566	Y	5/4/20	7/14/20
765	N	6/30/20	7/16/20

[amitchandak]

@syasmin25 ,

Not very clear.

Can you share sample sample output in a table format?

refer if this file can help

https://www.dropbox.com/s/bqbei7b8qbq5xez/leavebetweendates.pbix?dl=0

[syasmin25]

Hello, 

Thank you so much for your help. I am copying over the the the information from your file with an added column here. 

T_sample

id	Enter Date	Leave Date	Passed Test/Not
1	Thursday, August 19, 2019	Wednesday, April 1, 2020	Y
2	Thursday, August 18, 2019	Friday, March 20, 2020	N
3	Thursday, October 18, 2019	Tuesday, March 31, 2020	Y
4	Thursday, September 10, 2019	Wednesday, May 27, 2020	N
5	Thursday, August 19, 2019	Monday, July 20, 2020	Y

I have also connected them in an inactive relationship. The DimDate table is from your file that I have used here.

I am trying to calculate the Number of Users that have passed the test as a sample here. And I will be using the Date Column from DimDate table as slicer.


So far, I have tried the following but I am having issues trying to connect the Leave Date in the formula as well. 

Number of Users that have passed the test =

DIVIDE(

COUNTROWS(

CALCULATETABLE( VALUES( sample_tbl[id] ),

FILTER( VALUES( sample_tbl[Enter Date] ),sample_tbl[Enter Date] <= ( DimDate[Date] && CALCULATE(COUNT(sample_tbl[Passed Test/Not]),sample_tbl[Passed Test/Not]="Y") ))))

Thus, it currently looks somewhat like this.

Also, my auto date/time is turned off due to some other date related calculations.