Count Cases based on Days between Dates

[ARomain]

Trying to figure out the best way to do this.

I want to create a measure wheere I can Distinct Count cases where the FIRST Date of Request to Recieved Date is 15 days or less, as we can request items multiple times before we get them.

In the example below, Case 1 and 2 would be counted since the first request was 15 days or less. So my value would be 2. Case 3 had its first request 28 days before we got it and 4 was 19 days. The other dates do not matter, just the first. 

[ryan_mayu · Accepted solution]

@ARomain 

you can try to create a new column

Column = if('Table'[request date]=CALCULATE(min('Table'[request date]),ALLEXCEPT('Table','Table'[case id]))&&'Table'[Days Difference]<=15,1,0)

then you sum up the new column and you will get 2

[lbendlin · Accepted solution]

see attached

[Ahmedx · Accepted solution]

Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.

[lbendlin · Accepted solution]

see attached

[ryan_mayu · Accepted solution]

@ARomain 

you can try to create a new column

Column = if('Table'[request date]=CALCULATE(min('Table'[request date]),ALLEXCEPT('Table','Table'[case id]))&&'Table'[Days Difference]<=15,1,0)

then you sum up the new column and you will get 2