Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
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.
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
User | Count |
---|---|
98 | |
91 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
66 |