Median Filter

Question

Currently, I have the average revenue made on my dashboard. I would also like to make the median revenue too.

Problem is, I want the median revenue of the sum of each patient.

I want to sum up each patients revenue.... and then take the median of those sums. How do I go about that?

currently these are my codes:

AvgRevenue Per Patient = [Revenue] / 'Fewer Discounts'[Count of Invoices]

Count of Invoices = DISTINCTCOUNT('public view_transactions'[invoice_key])

amitchandak · Accepted Answer

Anonymous ,a ssuming revenue is a measure 
MEDIANX(values(Table[patient_id]), [revenue])

Forum Discussion