Forum Discussion
Median function error!!
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
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.
4 Replies
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.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.
Tried recreating your setup but am not getting the 1's that you are. Will wait for your file.
