Median function error!!

[Anonymous]

Hello Everyone,

I'm trying to calculate median of P by Date.
MEDIAN =MEDIAN(Table[p]) 
Median for 7,5,1 is 5 while i get 1

sample file --> Sample file

[Anonymous]

Hi @Anonymous ,

Any updates?

Best Regards,
Eyelyn Qin

[Anonymous · Accepted solution]

Hi @Anonymous ,

I have built a data sample:

Measure = MEDIAN('Table'[P])

Measure 2 = CALCULATE(MEDIAN('Table'[P]),ALLSELECTED('Table'))

Please always use the latest version of PBI. And if you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file after removing sensitive data.

How to Get Your Question Answered Quickly

How to provide sample data in the Power BI Forum

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[bcdobbs]

Hi, it won't let me access the file. I think may only be set to for access within your tennant.

I suspect the problem you're having is the filter context coming from the date but would like to see file first.

[bcdobbs]

Tried recreating your setup but am not getting the 1's that you are. Will wait for your file.