Help with calculating median stores sales...

[AWP]

Hello

I'd like some assistance please, I have sales data at a transaction level and therefore calculating the median transaction value was straight forward.

I'd now like to calculate the median store value sales. I think I need to summarise/group the data to the store level and then perform a median calculation. I've spent a lot of time researching and made exactly zero progress.

Could I please have some assistance with methodology and a DAX calculation?

Thank you

Andrew

[AWP · Accepted solution]

This worked for me...

Median Store Sales Sell (inc GST) =
MEDIANX(
SUMMARIZE(FCT_RETAIL_SALES,
DIM_STORE[ADDRESS_ID]
),
[Sales Sell (inc GST)]
)

[cjayaneththi]

Can you share data tables or pbix file?