Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi All,
I have patients medical claims data for 2 years FY 2017/2018 (FY runs from October 1st to Sept 30th). I have couple of tables like Fact_RX, DimProvider, DimDate,etc..The sample fact data looks like:
Service Date PatientID PhysicianID
2016-10-01 1 2
2016-12-01 2 45
2017-10-01 3 2
2018-10-11 1 3
2018-12-05 1 2
What I am trying to show in report is how many patients are New Starts in FY 2018(20171001 to 20180930 timeframe). I have this so far:
Patient Orders=
Hi,
You may download my PBI file from here.
Hope this helps.
@Ashish_Mathur Thanks for taking the effort to help me. However, When I don't have any filters on physician_ID its shows all patients are new Patients overall which is incorrect as Only PatientID 3 is new patient
Hi,
My solution return the number of new patients every month. So if no selection is made in the PhysicianID slicer, then you see new patients in each month for all Physician ID's
This is quite a complex topic with a relatively simple solution. In short you need to set up a star schema datamodel. You should create a patient dimension table and also a Calendar dimension table. When you use the ALL function for the patient table, it should do what you need. Note: I haven’t tested this - this is just my assumption of what the issue is.
@MattAllington I have all dimensions setup for Dates, Providers, etc... When I add New Patients on Tooltip anywhere in report, it shows me correct count but when I click on specific provider or any dimension it misses some patients.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
117 | |
101 | |
71 | |
61 |