Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Andrew Pearce]

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

——————————
Andrew Pearce
Business Analyst
Metcash
Sydney NS
0402236131
——————————

[John Broomfield]

What about the following:
Add a measure like this to the Sales FACT – Total Sales = SUM(quantity * Cost) 
Then add a measure like this to your Store DIM – Median Sale = MedianX ( Values(Store DIM[Store Name]) , Sales FACT[Total Sales] )

Something similar is mentioned here – Median of distinct total per month

Powerbi		remove preview
Median of distinct total per month Hi, I can’t believe how much difficulty this apparently easy problem is causing me. Below is a sample set of data. Imagine it to be a list of all sales to the customers of our company. We see that for instance in Month 1 we had 1 sale to customer AAA, 3 sales to BBB, 1 to CCC, and 2 sales to custome… View this on Powerbi >

Hope this is what you were after.

——————————
John Broomfield
Business Intelligence Analyst
LocalSearch
Robina
(07) 5526 7776
——————————
——————————————-