Forum Discussion
Filter for notes on same day by same provider
As a double check, we are wanting a dashboard to show notes when the same provider wrote two notes on the same day since it could be an accidental duplicate. I don't see how I can set it up to filter that way. Thanks for your help!
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 ...
6 Replies
Hi reast,
I don't know how your data are stored but did you try for example distinctcount when your filter for example a providor and the date?
Thx.
Count distinct would give me a number of distinct dates. What I want to do is show those notes that have the same date and provider.
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.
