Forum Discussion
Record Identification Measure or DAX
I am working on a dashboard for the healthcare org I work for and one of the asks for it is a page that displays patients that have not been seen for certain procedure codes in the last three years. I have already pulled three years worth of data. The columns in the data consist of patient name, date of birth, insurance member ID and procedure code that they were seen for. I obviously cannot share the actual data but I'm attaching a small data set that contains two patients and each patient it associated with multiple procedure codes.
The goal is to come up with a measure or DAX formula or maybe even Q code in the editor that looks at each patient in the data set and checks for if they are associated with certain listed procedure codes and if they are not then to be flagged by an indicator, it could be an X, anything that flags them and then they can be filtered on. For the example dataset I've attached the procedure codes to check for would be 99213 and 99463.
| Patient Name | Patient DOB | Member ID | Procedure Code |
| Sally Smith | 1/1/1990 | A10958675 | A1041 |
| Sally Smith | 1/1/1990 | A10958675 | 99213 |
| Sally Smith | 1/1/1990 | A10958675 | 99463 |
| Ben Rodriguez | 2/1/1980 | JBHN2469 | C4061 |
| Ben Rodriguez | 2/1/1980 | JBHN2469 | 99201 |
| Ben Rodriguez | 2/1/1980 | JBHN2469 | V7896 |
| Ben Rodriguez | 2/1/1980 | JBHN2469 | 98834 |
| Ben Rodriguez | 2/1/1980 | JBHN2469 | 21135 |
hello equevedo84
please check if this accomodate your need.
i assumed you have another table for procedure code to be checked which is 99213 and 99463 in this sample dataset. So, i made another table consisted of those two procedure codes.
the idea is to compare the exact same procedure code in both patient table and procedure table.
i used "X" as the outcome value, but you can change it with condition formating or symbol or any of your preferences.
Hope this will help.
Thank you.
6 Replies
hello equevedo84
please check if this accomodate your need.
i assumed you have another table for procedure code to be checked which is 99213 and 99463 in this sample dataset. So, i made another table consisted of those two procedure codes.
the idea is to compare the exact same procedure code in both patient table and procedure table.
i used "X" as the outcome value, but you can change it with condition formating or symbol or any of your preferences.
Hope this will help.
Thank you.
Hi,
Do you want a calculated column or a measure solution? Either ways, show the expected result.
Hi,
Do you want a calculated column or a measure solution? Either ways, show the expected result.
Hi equevedo84 ,
I wanted to check in on your situation regarding the issue. Have you resolved it? If you have, please consider marking the reply that helped you or sharing your solution. It would be greatly appreciated by others in the community who may have the same question.
Thank you.Hi equevedo84 ,
I wanted to check in on your situation regarding the issue. Have you resolved it? If you have, please consider marking the reply that helped you or sharing your solution. It would be greatly appreciated by others in the community who may have the same question.
Thank you.Hi equevedo84 ,
I just wanted to kindly follow up to see if you had a chance to review the previous response provided by us. I hope it was helpful. If yes, please Accept the answer so that it will be helpful to others to find it quickly.
Thank you.
