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
v-xjiin-msft's avatar
v-xjiin-msft
Solution 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.

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

        Hi Anonymous,

         

        Sorry for delayed reply.

         

        But I'm still getting the right result even with multiple grades. Thereby could you please share us your report file (pbix) if possible?

         

        Thanks,
        Xi Jin.