Forum Discussion
Filter for notes on same day by same provider
Hi reast,
I have created a measure like this ( My Table AutrData, I added 2 more providers for tests) :
Test = IF(COUNTX(AutrData,AutrData[ Date ])> 1 ,COUNTX(AutrData,AutrData[ Date ]),BLANK()).
Then with a matrix (See image below) I have this report ( does not show the blank ones).
Hope it helps ...
reast could you please send or show a sample ( with no critical data) in order to better understand.
Because if you use for example the matrix for report with provider in a row and a measure (to count or something like this), and in a filter your date, when you select a date ( in the filter), you will know for this date if the provider produced 2 or less notes...
Thx.
The idea is a provider would select her name from a filter and then in the table below would see the notes that she'd written when there was more than 1 for any given day. The data is something like below, but I want to filter out rows 3 and 6 because there's only one note on those days. Thanks!
Provider Date
Mary 1-1-17
Mary 1-1-17
Mary 2-2-17
Mary 3-3-17
Mary 3-3-17
Mary 4-4-17
Hi reast,
I have created a measure like this ( My Table AutrData, I added 2 more providers for tests) :
Test = IF(COUNTX(AutrData,AutrData[ Date ])> 1 ,COUNTX(AutrData,AutrData[ Date ]),BLANK()).
Then with a matrix (See image below) I have this report ( does not show the blank ones).
Hope it helps ...
Exactly what I needed. Thank you so much!!