Forum Discussion
Calculate(Sum) Measure creates multiple rows based on unrelated variables
In short, 1 units equals 15 min of a doctors time.
In this program, a patient is allowed 4 units for an assessment & 20 units for therapy.
The request is to have a weekly report showing how many units each patient has so there is time to get a reauthorization request submitted before the last appointment date.
My measures are counting fine however, when a patient switches insurance plans or has a birthday during the date range,
the chart creates 2 lines and I only want 1 line per patient.
Chart Explanation
In patient 'Jane', I have 12 units applied to Medicaid and 2 units applied to Trillium; the true remaining therapy units should be 6.
In patient 'Bullocken' the true remaining should be 14
*** Note, when the Credited insurance Carrier column is removed from the chart, the CALCULATE(SUM) function works fine but that column must be displayed.
I need help adding some dax to my measure(s) that counts all units but filters the insurance table to only display the last insurance used, BUT.....I don't know how to do that.
The base column that sets the unit paremiters says if medical cpt code 97802 is used, it gets 4 and if 97803 is used, it gets 20. The measures are built off this new column.
Remaining = Average (Allowed) - Sum (Applied) (while removing the Insurance and date filter)
Remaining Follow-up = CALCULATE(AVERAGE('Table'[Allowed Follow-up])-sum('Table'[Applied Follow-up]),REMOVEFILTERS('Table'[Service Date],'Table'[Insurance]))
