Forum Discussion

shantupm5's avatar
shantupm5
Helper III
3 years ago

MedianX Function

Hello,   I have the below data which is outcome of a Measure, And i want to derive Median of this outcome. I used formula   =CALCULATE(MEDIANX(VALUES('Customer[Customer]),[Achi %])) and i get the...
Need Help
Show and Tell
Tips and Tricks
shantupm5's avatar
shantupm5
Helper III
3 years ago

Here is the raw data

 

I have First Pass Orders and Total Orders. 

I had a measure to calcuate Customer wise First Pass %, which is sum of First pass orders / Total Orders. 

Then i need the median out of the results to identify the medain first pass %.

 

Please advice

Customer NameFirst Pass OrdersTotal Orders
Customer A 0
Customer A 0
Customer A 0
Customer A 0
Customer B 0
Customer B 0
Customer B 0
Customer B 0
Customer B 7
Customer B 6
Customer D 1022
Customer D 879
Customer D 888
Customer D 640
Customer D 371
Customer D 690
Customer D 549
Customer D 1246
Customer D 942
Customer D 572
Customer D 864
Customer C34373733
Customer C37854292
Customer C38884277
Customer C29063141
Customer C29173147
Customer C36014200
Customer C30073535
Customer C34353787
Customer C34203915
Customer C26202963
Customer C23642687
Customer E18102079
Customer E21252310
Customer E19932106
Customer E14871713
Customer E15841828
Customer E19592386
Customer E21422486
Customer E19122151
Customer E20712308
Customer E16221809
Customer E19402190
Customer E20222264
Customer D 1344
Customer F14004095
Customer F12003280
Customer F15003755
Customer F17003863
Customer F15003532
Customer F14004303
Customer F12504286
Customer F13004466
Customer F15004628
Customer F17005324
Customer F15505969
Customer F14504858
Customer A 470
Customer A 470
Customer A 470
Customer A 46
Customer A 11
Customer A 6
Customer A 2
Customer A 5
Customer B 175
Customer B 149
Customer B 87
Customer B 23
Customer B 27
Customer B 27
Customer C27413259
Customer G 59386
Customer G 59381
Customer G 59374
Customer G 59365
Customer G 59381
Customer G 59377
Customer G 59377
Customer G 59375
Customer G 59296
Customer G 59423
Customer G 59415
Customer G 59321
Customer F142327512
Customer F147826382
Customer F136526497
Customer F133326847
Customer F176524261
Customer F165427660
Customer F178224594
Customer F180325235
Customer F179925503
Customer F171222412
Customer F189224786
Customer F180423821
shantupm5's avatar
shantupm5
Helper III
3 years ago

Hello @v-yiruan-msft

 

Please can you reivew and advice

 

Regards

Prashanth