Number of patient each date with start and end date

[Enilv]

Hi , 

I want to have the number of patient every day on my organization. More precisly i want a graph with each day on absciss and the number of patient for this date. Moreover i want for example filter this graph by service name 

My data is organized like that in one table : 

I want something like that where filter could be apply

Thank you 

[Greg_Deckler]

So, I am assuming that the problem that you are running into is that you need to display patient counts when they are greater than or equal to the start date and less than or equal to the end date. I did this for a call center once. I'll have to dig up the solution but essentially it involved create a measure that did a count with the filters above as described and then putting it into a column chart with a date table's date as the axis, something along those lines. I'll have to dig it up and take a look.

[Enilv]

@Greg_Deckler

This is the pbix file file.zip

[Enilv]

Patient = 
CALCULATE (
DISTINCTCOUNT ( Feuil1[numero] );
FILTER (
Feuil1;
Feuil1[date1]
<= CALCULATE ( MAX ( Feuil2[date] ) )
);
FILTER (
Feuil1;
Feuil1[date2]
>= CALCULATE ( MIN ( Feuil2[date] ) )
)
)

I already realize something like that but filter doesn't work on my graph because there aren't linked as well