Median revenue

[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])

[v-shex-msft · Accepted solution]

HI @Anonymous,

You can create a variable table with summarize function to group based on current categories and summary these values, then you can use the iterator 'median' function to get the median number from this variable table records.

If you confuse about coding formula, please share some dummy data to test.

How to Get Your Question Answered Quickly

Regards,

Xiaoxin Sheng

[DataInsights]

@Anonymous,

Try these measures. I created a Patients table with one row per patient, with a relationship to the data table (star schema).

Sum Revenue = SUM ( Revenue[Revenue] )

Median Revenue = 
VAR vTable =
    ADDCOLUMNS ( VALUES ( Patients[Patient ID] ), "@SumRevenue", [Sum Revenue] )
VAR vResult =
    MEDIANX ( vTable, [@SumRevenue] )
RETURN
    vResult

Sample data:

Result:

[MFelix]

HI @Anonymous ,

For this type of calculations you need to use the aggregated syntax that are the ones that end with an X in this case you need to use MEDIANX should look similar to something similar to this:

MEDIANX(Values[Table[PatientID]), [Revenue])  

Be aware that this is only a mockup you may need to change the first parameter that is the table part.

https://dax.guide/medianx/