Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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  
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    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's avatar
bcdobbs
Icon for Community Champion rankCommunity Champion
4 years ago

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's avatar
bcdobbs
Icon for Community Champion rankCommunity Champion
4 years ago

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