Calculate the median days between events

[MrChuckles]

Thanks to Barry Houdini I was able to calculate the average days between events in a table. I have a sales table with fields for salesperson ID, Sales Date, Sale Amount. Each person can have one or many sales in the table. I am trying to calculate the median days between sales for each sales person and the median for the entire population of sales people.

I have tried Marco Russo's formula from here: SQLBI - Marco Russo : Median calculation in DAX but it doesn't work on a measure and I can't figure out how t build a calculated column that works.

That lead me to try Javier Gullian's formula from here: Calculating Median in PowerPivot / DAX | Javier Guillén which does work over a measure, but when I run it, it returns no values.

Has anyone else ever tried this and if so can you point me in the right direction?

Thanks,

Chuck