Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I am working on developing a dashboard where patients will be entering 4 health measures on daily basis: weight, blood pressure, temperature, and pulse ox readings.
Assuming the data flows through like such (Note: Data below is dummy data and in no way associated with a real patient):
I am trying to arrive at two tricky measures:
Thanks in advance!
Hi @SGiambrone ,
I hope I understand your intention correctly.
1. Try measure like this:
Measure = COUNTROWS(FILTER('Table',ISBLANK('Table'[VALUE1])&&ISBLANK('Table'[VALUE2])))
2. Try measure like this:
Measure 2 =
VAR total_reading_status =
CALCULATE ( COUNT ( 'Table'[Reding status] ), ALLSELECTED ( 'Table' ) )
VAR total_n =
CALCULATE (
COUNT ( 'Table'[Reding status] ),
FILTER ( ALLSELECTED ( 'Table' ), 'Table'[Reding status] = "N" )
)
RETURN
DIVIDE ( total_n, total_reading_status )
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Liang,
Thank you for sharing. Unfortunately, when a patient does not complete their "check-in", there is no record created in the data at all. Ideally, I would love it if the data would flow through as blank for those missed events.
Any other thoughts on how to accomplish this?
I hope there is a date table in your model, and a patient dimension table.
For 1 (assuming a 'missed check-in' is a row in the date dimension that doesn't have an entry in the Fact table) , create a simple measure like
NumVisits= COUNT(TableVisits[datevisit]) + 0
Pull date from the date table and id from the patient dimension on to a table visualisation. That should show all dates and number of visits. Once you've tested it and you're happy, you can use the filter pane to filter the measure = 0.
2. The ratio should be the same measure divided by 4. Or leave off the +0 if you're not interested in the 0% ones
Hi @HotChilli ,
Thanks for sharing your idea. So, assuming I followed this correctly, here is the resulting output when I create the visual table. I chose to show it by patient, by date. It does appear to be accurately capturing the # of check-ins and compliance rate at the date level. (ie. 4 = 100%, 3 = 75%, and so on).
How can I get the compliance to calculate correctly for each patient across the full date range? For example, overall compliance rate for Charlie Brown should be total check-ins divided by total "opportunity" (assuming 4 required each day) for whatever timeframe is selected.
Further, my ultimate end goal is to create two KPI card visuals (as opposed to just the table) that show the total # of missed check-ins, and overall compliance rate. These measures should be dynamic based on the filter selections (date range, patient, health action) - however high level or detailed the end user would like to see.
Thank you for your help! Any thoughts how to proceed further?
As you've written, create a measure that shows "total check-ins divided by total "opportunity" (assuming 4 required each day)"
To start (and for testing), create 2 measures, 1 to count visits, 1 to count days (x4).
Add them to the visual to see if they are correct.
When happy. create the final measure which divides visits/days * 4
User | Count |
---|---|
128 | |
108 | |
100 | |
64 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |