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.

Anonymous's avatar
Anonymous
Not applicable
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.