Filter for notes on same day by same provider

[reast]

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!

[Interkoubess]

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.

[reast]

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.

[Interkoubess]

@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.

[reast]

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

[Interkoubess · Accepted solution]

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]

Exactly what I needed. Thank you so much!!