Showing results for 
Search instead for 
Did you mean: 
Regular Visitor

Use SUMMARIZE table within weighted median calculation


I have the following DAX working CORRECTLY to calculate weighted median. It has two parts: first to create an aggregate table based on ID and ORG, and two calculated columns. Then, try to find the median paid amount based on the summarised table using a quite complex formula.


Is there a way that I can simplify this to put the SUMMARIZE function as a temporary thing inside the 'MedianPAID' measure?


PaymentSummaryTable = SUMMARIZE('Payment Table',
'Payment Table'[ID],
'Payment Table'[ORG],
"ORG_PAID",SUM('Payment Table'[PAID]),
"ORG_Weight",MIN('Payment Table'[WEIGHTS]))

MedianPAID=(MINX(FILTER(VALUES('PaymentSummaryTable'[ORG_PAID]), CALCULATE(SUM('PaymentSummaryTable'[ORG_Weight]),'PaymentSummaryTable'[ORG_PAID]<=EARLIER('PaymentSummaryTable'[ORG_PAID]))>SUM('PaymentSummaryTable'[ORG_Weight])/2),
+MINX(FILTER(VALUES('PaymentSummaryTable'[ORG_PAID]), CALCULATE(SUM('PaymentSummaryTable'[ORG_Weight]),'PaymentSummaryTable'[ORG_PAID]<=EARLIER('PaymentSummaryTable'[ORG_PAID]))>(SUM('PaymentSummaryTable'[ORG_Weight])-1)/2),


UPDATE: Here is the link to the Sample Data with the current set-up.

@Ibendlin Thanks for the suggestion!


Thank you so much in advance!



Super User
Super User

Please provide sanitized sample data that fully covers your issue. I cannot help you without usable sample data.
Please paste the data into a table in your post or use one of the file services like OneDrive or Google Drive. I cannot use screenshots of your source data.
Please show the expected outcome based on the sample data you provided. Screenshots of the expected outcome are ok.

Helpful resources

Vote for T-Shirt Design

Power BI T-Shirt Design Challenge 2023

Vote for your favorite t-shirt design now through March 28.

March 2023 Update3

Power BI March 2023 Update

Find out more about the March 2023 update.

March Events 2023A

March 2023 Events

Find out more about the online and in person events happening in March!

Top Solution Authors