Median Filter

[Anonymous]

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 solution]

@Anonymous ,a ssuming revenue is a measure

MEDIANX(values(Table[patient_id]), [revenue])