Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello PBI Community!
Thank you to all of those who have helped thus far with my questions. I have another hurdle needing assistance:
First, I have three (3) tables:
MASTER_PATIENT
MASTER_MEDICAL
MASTER_PHARMACY
MASTER_PATIENT has been set as the primary table and the relationships allow me to filter the other two tables via the relationships. My struggle is finding unique patients in the medical and pharmacy file based on a unique characteristic. This characteristic is a clinical category in a column that is named MEDC Code in the MASTER_MEDICAL file and Major Rx-MG Description in the MASTER_PHARMACY file. I'm trying to find unique patients who have the same code in both.
Here is a sample below:
MASTER_MEDICAL Table
Patient ID MEDC Code Plan Spend
123456789 CAR $100
ABCDEFGH RES $100
999999999 CAR $100
MASTER_PHARMACY Table
Patient ID Major Rx-MG Description Plan Spend
123456789 CAR $100
ABCDEFGH CAR $50
999999999 CAR $100
I created the following formula, but it isn't giving me the results. Using the example above, I would expect to get 3 unique CAR (Cardiovascular) patients:
Hi,
In the Master Patient Table, is there a clinical category column?
@Ashish_Mathur Hi Ashish,
There isn't. The clinical category is tied to a medical or pharmacy claim in their respective files. But, the three tables have the same patients in them, though some may appear in medical and not pharmacy and vice versa.
Hi,
Share the link from where i can download the PBI file. In that file, please ensure that only 3 Tables are present.
Hi @novotnajk ,
Thanks for the invite!
What does Master Patient look like? And the relationships?
Nathaniel
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
84 | |
67 | |
60 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |