Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Median Calculated Column using Dax

Hello All,   I have written measure for Median by using the below formula.   _Median = CALCULATE(MEDIAN('Emp Master'[Emp Count]),ALLSELECTED('Emp Master')) Now when i filter by SBU and PRACTICE ...
General Comment
Interesting Links
Need Help
Show and Tell
Tutorial Requests
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Thanks for the reply v-qiuyu-msft.

Median forumal worked.

 

But as i mentioned above in my question, i am grouping the median by grade here.

When i used the same formula but in calculated column it giving me wrong result. 

Measure Forumula:-

 

_Median By Measure = CALCULATE(MEDIAN('Emp Master'[Count]),ALLSELECTED('Emp Master'))

Calculated Column Formula:- 

 

_Median By Cal Col = CALCULATE(MEDIANX('Emp Master','Emp Master'[Count]*1.0),ALLSELECTED('Emp Master'))

Output:-

 

 

Can you please help me with this...

Anonymous's avatar
Anonymous
Not applicable
8 years ago

v-qiuyu-msft v-xjiin-msft can you please suggest me about this..

  • v-xjiin-msft's avatar
    v-xjiin-msft
    Icon for Solution Sage rankSolution Sage
    8 years ago

    Anonymous

     

    That's weird. I have made some test based on your sample data. Use Enter Data directly to create a source table. However the measure and calculated column with same expression return the same result.

     

    Please refer:

     

     

    Thereby, I think the issue is not related to the expression. Maybe it exists in other parts of your report. Please verify this.

     

    Thanks,
    Xi Jin.

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      v-xjiin-msft Thanks for the reply.

       

      I think you didnt checked with mulitple grades.

      I too used the same formula

       

      _Median = CALCULATE(MEDIANX('Emp Master','Emp Master'[Count]*1.0),ALLSELECTED('Emp Master'))

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        v-xjiin-msft v-qiuyu-msft Can you please give any suggestion regarding this..

         

        It will be lot helpful for me.