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

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
    Icon for Solution Sage rankSolution 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.