How to make a Median with a filter

[Anonymous]

I currently am finding the average of revenue per patient, but my boss is looking for a median revenue per patient.

Currently what I have is:

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

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

Not sure how to go about getting the median of the revenue of per patient.

Help!  Thanks in advance

[aj1973 · Accepted solution]

Hi @Anonymous 

In DAX there is a formula for it

https://docs.microsoft.com/en-us/dax/median-function-dax

Also in some visuals there is a direct way to see Median