Forum Discussion

reast's avatar
reast
Helper II
9 years ago
Solved

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...
Need Help
  • Interkoubess's avatar
    Interkoubess
    9 years ago

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

Interkoubess's avatar
Interkoubess
Solution Sage
9 years ago

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's avatar
reast
Helper II
9 years ago

Exactly what I needed. Thank you so much!!